If cell = date return yes or no. [Solved/Closed]

 Kicho -

I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes, No) but I keep getting #name errors.

If its any help, the cell with the date (I12) is retreiving it via a vlookup function and is not just a date entered manually.

The only other value in I12 will be an #n/a error. Is it possible to use ISNA to return no if true and yes if false?

Could anyone help?

System Configuration: Windows XP / Internet Explorer 7.0

2 replies

My final forumla is now


Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Registration date
Sunday June 14, 2009
Last seen
July 30, 2015
"date" in excel is a number

suppose the date (entered correctly according to regional format) is in C1

try in another empty cell this formula


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!