A client had data in the form 30/09/2011, 23/04/2012, etc. Their financial year was 1st July to 30th 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:
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.
Find more information about our Microsoft Excel training Sydney, Australia.