mimic Working Days in ATP
 

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

mimic Working Days in 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(INDI
RECT("1:"&ABS(days)*10))),holidays,0)),ROW(INDIREC T("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)


"Mika" wrote in message
ups.com...
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

mimic Working Days in ATP
 

Thanks a lot Bob !

mimic Working Days in ATP
 

look at NETWORKDAYS

Glen
"Mika" wrote in message
ups.com...
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

mimic Working Days in ATP
 

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

On Fri, 4 Mar 2005 12:16:38 -0600, "Glen Mettler"
wrote:

look at NETWORKDAYS

Glen
"Mika" wrote in message
oups.com...
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