year function and financial years
one way:
instead of
=YEAR(A1)
use
=YEAR(DATE(YEAR(A1),MONTH(A1)-3,1))
In article ,
"Martin_London" wrote:
In the UK our financial year runs April to March. Is there any way of using
the =year() function on a date so that it runs on these dates rather than
calender years? Basically I need Jan, Feb and March of next year to be
recognised as the same year as April to December of this year.
|