hi,
is there a way to calculate the finacial period from a date?
i.e. 01/04/07 is period 1 in finacial terms
so the date July-07 would return '4' as in period 4
Thanks,
Jon
hi,
is there a way to calculate the finacial period from a date?
i.e. 01/04/07 is period 1 in finacial terms
so the date July-07 would return '4' as in period 4
Thanks,
Jon
Last edited by jonn; 07-02-2007 at 11:52 AM.
Maybe
=MONTH(DATEVALUE("01/07/07"))-3
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks