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!?
Try this formula
=IF(A2=DATE(2014,8,1),"Existing",IF(A2<DATE(2014,8,1),"Out of Date",IF(A2>DATE(2014,9,1),"Upcoming","")))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
THats great! thanks!!
this should also work
Please Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Sorry it doesn't pick up that the 2015 dates are Upcoming?
It works!! thank you
which one? or both?....just curious
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks