Previous Topic Next Topic

If cell = date return yes or no.

Solved/Closed
JD - 16 Jan 2011 à 17:34
 ndwebb - 20 Dec 2021 à 11:50
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
Related:

2 responses

Réponse 1 / 2
JD
16 Jan 2011 à 21:24
My final forumla is now 

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


Thanks.
Kicho
17 Dec 2018 à 02:15
Thank you !
ndwebb
20 Dec 2021 à 11:50
This really helped! I kept getting an error and this resolved it.

Similar discussions

Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Excel: If Date =, then enter a value
JerrySD -
BrianGreen -

4 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses