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.
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.
Has anyone else ran acroos this and solved or know of a solution?
Thanks,
Gary
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