T
Turnipboy
I need to put the current fiscal period and year into a cell. Our fiscal
year starts in October, which is period 1, November is period 2, through
to September which is period 12. As the fiscal year runs October -
September, it is named after the year it mostly falls in, so for
instance Dec 2005 is 3/2006 (period/fiscal year).
Is there a way to automatically put the period and year in a cell (it
is normally written in the form period/fiscal year - but this is not
essential), by adapting the =TODAY() function or otherwise.
Thanks.
year starts in October, which is period 1, November is period 2, through
to September which is period 12. As the fiscal year runs October -
September, it is named after the year it mostly falls in, so for
instance Dec 2005 is 3/2006 (period/fiscal year).
Is there a way to automatically put the period and year in a cell (it
is normally written in the form period/fiscal year - but this is not
essential), by adapting the =TODAY() function or otherwise.
Thanks.