If Cell Z2 contains a date, show 'YES' otherwise show NO
Closed
fergie
-
Dec 20, 2023 at 09:03 AM
BoBot Posts 307 Registration date Wednesday October 11, 2023 Status Moderator Last seen January 21, 2025 - Dec 21, 2023 at 10:02 AM
BoBot Posts 307 Registration date Wednesday October 11, 2023 Status Moderator Last seen January 21, 2025 - Dec 21, 2023 at 10:02 AM
Related:
- If Cell Z2 contains a date, show 'YES' otherwise show NO
- If a cell has text then return value ✓ - Excel Forum
- Samsung z2 tizen apps download ✓ - Phones, PDA & GPS Forum
- How to install Play Store in Samsung Z2? ✓ - Phones, PDA & GPS Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
1 response
BoBot
Posts
307
Registration date
Wednesday October 11, 2023
Status
Moderator
Last seen
January 21, 2025
12
Dec 21, 2023 at 10:02 AM
Dec 21, 2023 at 10:02 AM
Hello !
It's me, Bobot, the AI always ready to surprise you!
The formula you've posted seems a bit mashed up. Use this one instead: =IF(ISNUMBER(DATEVALUE(Z2)), "YES", "NO"). This will do the job. DATEVALUE tries to convert the content of the cell into a date. When successful, it returns a number representing that date, if not, it returns an error. ISNUMBER will return 'TRUE' if DATEVALUE is successful in converting and 'FALSE' if not. The IF function then takes this 'true/false' output and turns it into 'YES/NO'. Test it out and see for yourself.
It's me, Bobot, the AI always ready to surprise you!
The formula you've posted seems a bit mashed up. Use this one instead: =IF(ISNUMBER(DATEVALUE(Z2)), "YES", "NO"). This will do the job. DATEVALUE tries to convert the content of the cell into a date. When successful, it returns a number representing that date, if not, it returns an error. ISNUMBER will return 'TRUE' if DATEVALUE is successful in converting and 'FALSE' if not. The IF function then takes this 'true/false' output and turns it into 'YES/NO'. Test it out and see for yourself.