Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
mimic Working Days in ATP
Thanks a lot Bob !
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate working days but change working week | Excel Discussion (Misc queries) | |||
Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
How to calculation no. of days (only working days) between two dat | Excel Discussion (Misc queries) | |||
5.5 working days | Excel Discussion (Misc queries) | |||
How to Add 5 working days | Excel Discussion (Misc queries) |