If today = any date in November, how can I display in a seperate cell that that is month 8 of an April - Mar Financial year.
A4 =Today() 18/11/09
a5 = can this display as 8 and then 9 when a4 becomes a december date?
Any help much appreciated.
If today = any date in November, how can I display in a seperate cell that that is month 8 of an April - Mar Financial year.
A4 =Today() 18/11/09
a5 = can this display as 8 and then 9 when a4 becomes a december date?
Any help much appreciated.
Last edited by Gooford; 11-19-2009 at 10:00 AM.
=mod(month(a4)-3,12)
A few routes, one might be:
=1+DATEDIF("01/04/09",A4,"m")
Last edited by DonkeyOte; 11-19-2009 at 09:54 AM. Reason: replaced TODAY with ref to A4
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thank you both - excellent
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks