Microsoft Excel – finding financial year from a date

A client had data in the form 30/09/2011, 23/04/2012, etc. Their financial year was 1^st July to 30^th June, and they wanted an Excel column Financial year which was in the form 2010-2011, 2011-2012, etc.

If the first date to be converted is in cell A2, place your cursor in cell B2, and enter the following formula:

=IF(MONTH(A2)<=6,YEAR(A2)-1&”-” &YEAR(A2),YEAR(A2)&”-”&YEAR(A2)+1)

Use the Autofill handle to fill in the rest of the financial years.

If March is the end of the financial year, it would be MONTH(A2)<=3, etc.

For more information about our Microsoft Excel training Sydney, Australia, please visit http://www.jmdtraining.com.au/microsoft-office-training/microsoft-excel-training.

For more information about our Microsoft Excel training London, UK, please visit http://www.jmdtraining.co.uk/microsoft-office-training/microsoft-excel-training.

About these ads