Add the specified number of work days to the a date.
 

Can someone know how i can get the date after adding to another date some
working days?

Let's say that now we have 2005-10-13, if i add 5 working days i must get
as a result the 2005-10-20 .(not include sun and sat).
Can anyone have a forumula. (Not with the analysis toolpack) just simple
formula or vba for excel 97.

Add the specified number of work days to the a date.
 

Why not the ATP?

=start_date+SIGN(B1)*SMALL(IF((WEEKDAY(start_date+ SIGN(days)*(ROW(INDIRECT("
1:"&ABS(days)*10))))={1,2,3,4,5})*
ISNA(MATCH(start_date+SIGN(days)*(ROW(INDIRECT("1: "&ABS(days)*10))),holidays
,0)),ROW(INDIRECT("1:"&ABS(days)*10))),ABS(days))

it is an array formula, so commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

"gus" wrote in message
...
Can someone know how i can get the date after adding to another date some
working days?

Let's say that now we have 2005-10-13, if i add 5 working days i must
get
as a result the 2005-10-20 .(not include sun and sat).
Can anyone have a forumula. (Not with the analysis toolpack) just simple
formula or vba for excel 97.

Add the specified number of work days to the a date.
 

Thanks it worked


"Bob Phillips" wrote in message
...
Why not the ATP?

=start_date+SIGN(B1)*SMALL(IF((WEEKDAY(start_date+ SIGN(days)*(ROW(INDIRECT("
1:"&ABS(days)*10))))={1,2,3,4,5})*
ISNA(MATCH(start_date+SIGN(days)*(ROW(INDIRECT("1: "&ABS(days)*10))),holidays
,0)),ROW(INDIRECT("1:"&ABS(days)*10))),ABS(days))

it is an array formula, so commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

"gus" wrote in message
...
Can someone know how i can get the date after adding to another date some
working days?

Let's say that now we have 2005-10-13, if i add 5 working days i must
get
as a result the 2005-10-20 .(not include sun and sat).
Can anyone have a forumula. (Not with the analysis toolpack) just simple
formula or vba for excel 97.