View Single Post
 
Old 10-27-2017, 07:25 AM
LearningMom LearningMom is offline Windows Vista Office 2007
Novice
 
Join Date: Feb 2015
Posts: 8
LearningMom is on a distinguished road
Default 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
Reply With Quote