I have 2000 rows of dates - all in the format mm.dd.yyyy, ranging from 01.01.1995 to 01.01.2007. I need to label them into their appropriate Financial Years.
e.g. FY96 04.01.1995 to 03.31.1996
FY97 04.01.1996 to 03.31.1997
Should I just use a combination of IF and AND formulas to help me do this? If so, does anyone know how?
e.g. FY96 04.01.1995 to 03.31.1996
FY97 04.01.1996 to 03.31.1997
Should I just use a combination of IF and AND formulas to help me do this? If so, does anyone know how?