LinkBack URL
About LinkBacks
Tweaking Jason's formula..
=YEAR(EOMONTH(A2,-7))&"-"&YEAR(EOMONTH(B2,5))-1.
Note:
Fiscal year 2007 begins Aug 1, 2007
Fiscal year 2008 begins Aug 1, 2008 and so on
Tweaking Jason's formula..
=YEAR(EOMONTH(A2,-7))&"-"&YEAR(EOMONTH(B2,5))-1.
Note:
Fiscal year 2007 begins Aug 1, 2007
Fiscal year 2008 begins Aug 1, 2008 and so on
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks