I have a lot of dates ranging from 2013 - 2015
I want to create if statements so by if a date is surpassed then the if statement result will change.
i.e.
=IF(a2=1/8/2014,"Existing",IF(a2<1/8/2014,"Out of Date",IF(a2>1/9/2014,"Upcoming")))
All dates begin with a the first day of the month - however when I use this formula the only result that comes up is "Upcoming"
Please can you help!?
Bookmarks