Project future date w/ 6 day work week and holiday

D

damucol

How can I calculate a future date based on a start date, taking in
consideration holidays?
 
D

daddylonglegs

I assume you count Sunday as the only non-workday

Assuming start date in A2, workdays to add in B2, list of holiday dates
defined as named range holidays


=A2+SMALL(IF((WEEKDAY(A2+ROW(INDIRECT("1:"&B2*10)))>1)*ISNA(MATCH(A2+ROW(INDIRECT("1:"&B2*10)),holidays,0)),ROW(INDIRECT("1:"&B2*10))),B2)

confirmed with CTRL+SHIFT+ENTER

format as date
 
D

damucol

It did not work! The result is #NUM on the cell. What am I doing wrong?
The cell is formated as date. what kind of confirmation is required for
CTRL+SHIFT+ENTER? I have the list of holidays on a spreadsheet that I am
calling Holidays and the dates are located between cells B9:B30.
 
Top