Indian Financial Year Month Number in Excel

The Indian Financial Year start on 1 April. Like Australia its Financial Year month numbers can be painful. Here is a formula to sort them out.

The image below shows this year’s months and a few for next year.

The formula in cell B2 which has been copied down is

=MONTH(A2)+IF(MONTH(A2)>3,-3,9)

The MONTH function returns a number from 1 to 12 representing the calendar year month number.

This formula takes the calendar year month number and deducts 3 if the number is above 3 or adds 9 if the number is 3 or below.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

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