mimic Working Days in ATP

[Mika]

Hi Guys,

I am quite in a hurry and don´t have the time to search this group for
what I am looking for:

I need a ws function (not VBA) to do exactly the same that Working days
in the ATP add in.

I am sure that somebody already answered that... Mirna Larson perhaps ?

Rgds
Mika

 

[Bob Phillips]

=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(INDI
RECT("1:"&ABS(days)*10))),holidays,0)),ROW(INDIRECT("1:"&ABS(days)*10))),ABS
(days))

start_date and days are named ranges, holidays is a list of dates

this is an array formula

--

HTH

RP
(remove nothere from the email address if mailing direct)


Hi Guys,

I am quite in a hurry and don´t have the time to search this group for
what I am looking for:

I need a ws function (not VBA) to do exactly the same that Working days
in the ATP add in.

I am sure that somebody already answered that... Mirna Larson perhaps ?

Rgds
Mika

 

[Mika]

Thanks a lot Bob !

 

[Glen Mettler]

look at NETWORKDAYS

Glen
Hi Guys,

I am quite in a hurry and don´t have the time to search this group for
what I am looking for:

I need a ws function (not VBA) to do exactly the same that Working days
in the ATP add in.

I am sure that somebody already answered that... Mirna Larson perhaps ?

Rgds
Mika

 

[Myrna Larson]

Except that it's part of the ATP, which he said he doesn't want.