Can anyone tell me why this formula is not working. I have a date of 4/12/10 in C3 and it is saying active when it should be expired based this formula
=IF(C3>=5/1/10,"Active","Expired")
Can anyone tell me why this formula is not working. I have a date of 4/12/10 in C3 and it is saying active when it should be expired based this formula
=IF(C3>=5/1/10,"Active","Expired")
Last edited by ClikClak; 05-21-2010 at 02:51 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks