If cell = date return yes or no.

Solved/Closed
JD - Updated on Dec 17, 2018 at 06:14 AM
 ndwebb - Dec 20, 2021 at 11:50 AM
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

2 replies

My final forumla is now

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


Thanks.
16
Thank you !
0
This really helped! I kept getting an error and this resolved it.
0