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
|