Excel and fiscal dates

I keep having to remember the fiscal year formulae for Excel – fiscal year starts July 1, ends June 30.

Here’s my note so I can remember:

Fiscal year:  =IF(MONTH([cell])>6,YEAR([cell])+1,YEAR([cell]))

Fiscal month: ==IF(MONTH([cell])>6,MONTH([cell])-6,MONTH([cell])+6)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.