Excel: If Date =, then enter a value
Solved/Closed
JerrySD
Posts
2
Registration date
Thursday November 12, 2015
Status
Member
Last seen
November 12, 2015
-
Nov 12, 2015 at 04:53 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Nov 13, 2015 at 12:42 PM
BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Nov 13, 2015 at 12:42 PM
Related:
- If cell contains date then return value
- Excel if cell contains date then return value - Best answers
- If cell contains a date then return value - Best answers
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Dash becomes date on excel ✓ - Office Software Forum
- Kernel for excel - Download - Backup and recovery
2 responses
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
149
Nov 12, 2015 at 05:44 PM
Nov 12, 2015 at 05:44 PM
Would changing the enquiry help here ... instead of asking for a specific date then how about asking for ANY date? The expression then becomes...
=IF(ISNUMBER(A8),"1","0")You then need to format cell A8 as a date.
Nov 12, 2015 at 06:10 PM