Excel Tips

Words in capital letters are Excel functions.

How do I calculate the financial year from a given date

Financial year=YEAR(DATE(YEAR(Given_Date),MONTH(Given_Date)+(Start_Month-1),1))


Where Given_Date  is the full date & Start_Month is the first month of the financial year.

How do I calculate the financial quarter from a given date

For a financial year commencing in July

Quarter=CHOOSE(MONTH(Given_Date),3,3,3,4,4,4,1,1,1,2,2,2)


For a financial year commencing in January

Quarter=CHOOSE(MONTH(Given_Date),1,1,1,2,2,2,3,3,3,4,4,4)