 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Input Fiscal Year.
I've been trying to create a formula that would convert a day into the current fiscal year, For instance, July 1st is the beginning of fiscal year 08, so if cell b3 reads 7/15/07, I would like cell a3 to read FY 08. Thanks in advance, David Try this: A3: ="FY "&RIGHT((YEAR(B3)-(MONTH(B3)<7)),2) Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > I've been trying to create a formula that would convert a day into the > current fiscal year, For instance, July 1st is the beginning of fiscal > year 08, so if cell b3 reads 7/15/07, I would like cell a3 to read FY 08. > > Thanks in advance, > David -------------------------------------------------------------------------------- > I've been trying to create a formula that would convert a day into the > current fiscal year, For instance, July 1st is the beginning of fiscal > year 08, so if cell b3 reads 7/15/07, I would like cell a3 to read FY 08. > > Thanks in advance, > David
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.