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

JD - Jan 16, 2011 at 05:34 PM - Latest reply:  JD
- Jan 16, 2011 at 09:24 PM

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?

See more 

3 replies

Best answer
venkat1926 1865 Posts Sunday June 14, 2009Registration dateContributorStatus July 30, 2015 Last seen - Jan 16, 2011 at 08:40 PM
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


Thank you, venkat1926 1

Something to say? Add comment

CCM has helped 1902 users this month

Thank you
Thank you
My final forumla is now