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

-
Hello,

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
5
Thank you
My final forumla is now

=if(isnumber(I12),"yes","no")


Thanks.

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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
784
1
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

=isnumber(C1)