How to convert dates into financial years

Hi Teresa,


Thank you for the forum question.

The best solution is to have a financial years column in the Date table and use this financial years column in visuals where your numbers need to be shown by financial years.

If your financial years starts 1 April

financial years = YEAR(EDATE([Dates],9))


[Dates] is the column header in which you have the dates.





Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector