Formula to return "Yes" if the cell is a date

[GaryG9595]

Hello Everyone,
I am trying to return the value "Yes" in cell B1 if A1 is a date and "No" if it is not.
Seems pretty simple, and I can't be the first person to need this.

Data	Results Needed
2/23/2023	Yes
123	No
car	No
home	No
2/4/2023	Yes
3/3/2023	Yes
32154	No

I have searched, but could not find a solution. Used Chat GPT as well.
I cannot find a way to differ a number from a date.
I have tried the following formulas, and none of them worked.

IFERROR(IF(ISTEXT(A2),"No",IF(ISNUMBER(A2),IF(INT(A2)=A2,"No","Yes"),"No")),"No")

IF(ISNUMBER(DATEVALUE(A2)),"Yes","No")

IF(ISTEXT(A2),"No","Yes")

IF(ISNUMBER(A2), "No", IF(ISDATE(A2), "Yes", "No"))

IF(ISNUMBER(A2)+ISDATE(A2)=1,"Yes","No")

IFERROR(IF(A2<>"", IF(ISNUMBER(A2)*NOT(ISDATE(A2)), "No", "Yes"), ""), "")

IF(ISNUMBER(A2), IF(ISDATE(A2), "Yes", "No"), "No")

IF(OR(ISNUMBER(A2),A2="Yes"), "Yes", "No")

IF(AND(ISDATE(A2)), "Yes", "No")

IFERROR(IF(ISDATE(A2),"Yes","No"), "No")

IF(OR(ISNUMBER(A2),ISDATE(A2)), "Yes", "No")

IFERROR(IF(OR(ISNUMBER(A2),ISDATE(A2)), "Yes", "No"), "No")

IFERROR(IF(VALUE(A2)>0,IF(ISTEXT(A2),"No","Yes"),"No"),"No")

IF(ISNUMBER(A2), IF(INT(A2)=A2, "Yes", "No"), "No")

IF(ISNUMBER(A2), "No", IF(ISNUMBER(DATEVALUE(A2)), "Yes", "No"))

IFERROR(IF(AND(ISNUMBER(A2),ISDATE(A2)), "Yes", "No"), "No")

IFERROR(IF(ISTEXT(A2), "No", IF(ISNUMBER(A2), "No", IF(ISNUMBER(DATEVALUE(A2)), "Yes", "No"))), "No")

IFERROR(IF(VALUE(A2)=INT(VALUE(A2)), "Yes", "No"), "No")

IFERROR(IF(AND(VALUE(A2)=INT(VALUE(A2)), NOT(ISNUMBER(A2))), "Yes", "No"), "No")

IFERROR(IF(OR(ISNUMBER(A2),ISBLANK(A2)), "No", IFERROR(DATEVALUE(A2),"No")), "No")

Has anyone else ran acroos this and solved or know of a solution?
Thanks,
Gary

 

[JamesCanale]

The cell function is a bit wonky and volatile sometimes. But it might serve.

MrExcelPlayground16.xlsx
	A	B
1	3/4/2023	Yes
2	42512	No
3	Potato	No
4	123	No
5	1/1/2000	Yes
6	5/6/2010	Yes
7		No
8		No
9		No
10	1/1/2000	Yes
11		No
12		No
13	1/1/2000	Yes
14	1/1/2000	Yes
15	1/1/2000	Yes
16	1/1/2000	Yes
Sheet7

Cell Formulas
Range	Formula
B1:B16	B1	=IF(LEFT(CELL("format",A1),1)="D","Yes","No")

 

[Fluff]

How about

=IF(LEFT(CELL("format",A2))="D","Yes","No")

 

[GaryG9595]

That Works. You both were on the same page.
I guess we are all still safe from AI....
Thanks again.

 

[Fluff]

Glad we could help & thanks for the feedback.