IF cell contains date, ten return "yes" in another cell.

[MWhiteDesigns]

I know this is an If statement, however how do you indicate the date?
If O3 contains date, then Yes in B3.

 

[Firefly2012]

Ok - try this:

=IF(COUNTA(A3:O3)=0,"",IF(ISNUMBER(O3),"Yes","No"))

 

[JozefMJ]

=IF(DATE(TEXT(O3;"yyyy");TEXT(O3;"mm");TEXT(O3;"dd"));Yes;"")

- depends on date format

 

[jtakw]

=IF(DATE(TEXT(O3;"yyyy");TEXT(O3;"mm");TEXT(O3;"dd"));Yes;"")

- depends on date format

Hi,

This thread is over 10 years old.

And that will return Yes for any positive number, and errors if it's Text:

Book3.xlsx
	O	P
3	1	Yes
4	abc	#VALUE!
5	3	Yes
Sheet5

Cell Formulas
Range	Formula
P3:P5	P3	=IF(DATE(TEXT(O3,"yyyy"),TEXT(O3,"mm"),TEXT(O3,"dd")),"Yes","")

 

[JozefMJ]

Hi,

This thread is over 10 years old.

And that will return Yes for any positive number, and errors if it's Text:

Book3.xlsx
	O	P
3	1	Yes
4	abc	#VALUE!
5	3	Yes
Sheet5

Cell Formulas
Range	Formula
P3:P5	P3	=IF(DATE(TEXT(O3,"yyyy"),TEXT(O3,"mm"),TEXT(O3,"dd")),"Yes","")

Ok, thanks for reflexion.