Formula for looking at 1 cell with a date and then comparing it to four date ranges
We have one column with a last date gave. We want to write a formula that looks at that cell and outputs a "0" if it is before 06/30/2014 outputs a "1" if the date in the cell is between 7/1/2014 and 6/30/2015 and then a "2" if it is between 7/1/15 and 6/30/16 and a "3" between 7/1/16 and 6/30/18
Thank you
|