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 … Continue reading Indian Financial Year Month Number in Excel