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


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
See more 

2 replies

Best answer
approved by Jean-François Pillou on Nov 30, 2018
Thank you
My final forumla is now



Say "Thank you" 5

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

CCM 6347 users have said thank you to us this month

Registration date
Sunday June 14, 2009
Last seen
July 30, 2015
Thank you
"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