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

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


Thanks.

Say "Thank you" 3

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 3765 users have said thank you to us this month

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