In Excel 2013, I have a date range for the product period:
Column A contains Start Date Eg. 01-AUG-2014 Column B contains End Date Eg. 31-JUL-2015
In Column C I need to map the financial year, which should be 2014-15. Financial year starts on April 1 and ends on March 31 the next year.
My data has financial year from 2001-02 to 2015-16, and currently I write lengthy IF, THEN formulas.
Is there any easier way to do it.