this should also work
![]()
=IF(A2=DATEVALUE("1/8/2014"),"Existing",IF(A2<DATEVALUE("1/8/2014"),"Out of Date",IF(A2>DATEVALUE("1/9/2014"),"Upcoming")))
this should also work
![]()
=IF(A2=DATEVALUE("1/8/2014"),"Existing",IF(A2<DATEVALUE("1/8/2014"),"Out of Date",IF(A2>DATEVALUE("1/9/2014"),"Upcoming")))
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks