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
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
- Nov 13, 2015 at 12:42 PM
I am using this formula and it works well: =IF(A8=DATE(2015,3,27),"1","--")

How do I now create a string to check a number of dates (company holidays)?

2 replies

BrianGreen
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
148
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.
2
JerrySD
Posts
2
Registration date
Thursday November 12, 2015
Status
Member
Last seen
November 12, 2015

Nov 12, 2015 at 06:10 PM
Thank you for the quick reply. I am so sorry I was unclear when I mentioned "company holidays". Since these are specific dates, "ANY" date will not work.
0