LinkBack URL
About LinkBacks
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.
Try this:
=IF(C3>=DATEVALUE("5/1/10"),"Active","Expired")
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
That did it, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks