I need to update a current formula for it to leave blank the formula cell if it encounters anything that is NOT a date (for instance, HOLD, TBD, blank cells, etc.) in the cell it is using to calculate. Both columns (Q and R) are formatted as dates.
The formula is in cell R2 (Target Date) and it takes the date from Q2 (Date Received) and adds to it 5 days, considering weekends and holidays.
Here is the formula in cell R2 thus far:
=WORKDAY(Q2,5,HOLIDAYS!A:A)
So if my Date Received (Q2) is 1/2/2018, my Target Date (R2) should be 1/9/18 (5 days from 1/2/18 considering the weekend).
Note: Since I have a list of holidays that are unique to our company, I created a list of these in a separate "HOLIDAYS" worksheet - that is why you see the reference to that worksheet.
Thank you
Bookmarks