Excel: If Date =, then enter a value [Solved/Closed]
JerrySD
Moderator Last seen
November 12, 2018
- Nov 13, 2015 at 12:42 PM
- Posts
- 2
- Registration date
- Thursday November 12, 2015
- Last seen
- November 12, 2015
- Posts
- 983
- Registration date
- Saturday January 17, 2015
- Status
- Excel if date
- Excel if cell contains date then return value - Best answers
- Excel "IF" function w/ date in test cell ✓ - Forum - Excel
- Excel if date is between range then - How-To - Excel
- Excel automatic date change formula - How-To - Excel
- Excel change date format ✓ - Forum - Excel
- Excel is date ✓ - Forum - Office Software
4 replies
Best answer
- Posts
- 983
- Registration date
- Saturday January 17, 2015
- Status
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.
has helped 1621 users this month- Posts
- 122
- Registration date
- Tuesday August 31, 2010
- Status
Brian is correct that you really shouldn't need to be entering hard-coded dates into formulas.
To achieve what you need.
1. Create a new sheet (called "CompanyDates") containing the dates that are deemed to be 'company holidays'
2 Enter this formula:
This will check the date in cell B2 and return a '--' if the date is not in the company holiday list or 1 if it is.
Even if more dates are added to the list (next year) it will still work.
To achieve what you need.
1. Create a new sheet (called "CompanyDates") containing the dates that are deemed to be 'company holidays'
2 Enter this formula:
=IF(ISNA(MATCH(B2,CompanyDates!A:A,0)),"--",1)
This will check the date in cell B2 and return a '--' if the date is not in the company holiday list or 1 if it is.
Even if more dates are added to the list (next year) it will still work.
- Posts
- 983
- Registration date
- Saturday January 17, 2015
- Status
Thanks Ray :)
- Posts
- 2
- Registration date
- Thursday November 12, 2015
- Last seen
- November 12, 2015
- Nov 12, 2015 at 06:10 PM