Project future date w/ 6 day work week and holiday
 

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

Project future date w/ 6 day work week and holiday
 

Assuming a 6 day week

"damucol" wrote:

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

Project future date w/ 6 day work week and holiday
 

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)),holid ays,0)),ROW(INDIRECT("1:"&B2*10))),B2)

confirmed with CTRL+SHIFT+ENTER

format as date

"damucol" wrote:

Assuming a 6 day week

"damucol" wrote:

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

Project future date w/ 6 day work week and holiday
 

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.

"daddylonglegs" wrote:

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)),holid ays,0)),ROW(INDIRECT("1:"&B2*10))),B2)

confirmed with CTRL+SHIFT+ENTER

format as date

"damucol" wrote:

Assuming a 6 day week

"damucol" wrote:

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