Financial Year in Excel

This formula will give the financial year a date occurred in.

This assumes that the date is in A1.

=IF(MONTH(A1)<4,YEAR(A1)-1&"-"&RIGHT(YEAR(A1),2),YEAR(A1)&"-"&RIGHT(YEAR(A1)+1,2))

This can be altered for acadamic year by replacing the 4 with a 9 (academic months start in September, not April)

Advertisements