Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Networkdays
I know the networkdays automatically calculates the monday to friday
routine between two dates. How can I howether compare two dates that doesn't count friday as a workday also, as well as the normal saturday and sunday? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Networkdays
1 way
=NETWORKDAYS(A10,A11,B8:B40) where a10 start date a11 end date B8:B40 every friday between those 2 dates (Easy to create with autofill) Mike "Dave" wrote: I know the networkdays automatically calculates the monday to friday routine between two dates. How can I howether compare two dates that doesn't count friday as a workday also, as well as the normal saturday and sunday? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Networkdays
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(start_date&":"&end_date)),2) ={1,2,3,4}))
-SUMPRODUCT(--(COUNTIF(holidays,(ROW(INDIRECT(start_date&":"&end _date)))*(WEEKDAY(ROW(INDIRECT(start_date&":"&end_ date)),2)={1,2,3,4})))) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Dave" wrote in message ups.com... I know the networkdays automatically calculates the monday to friday routine between two dates. How can I howether compare two dates that doesn't count friday as a workday also, as well as the normal saturday and sunday? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Networkdays
If you aren't worried about holidays
=SUM(INT((8-WEEKDAY(end_date-{1,2,3,4})+end_date-start_date)/7)) If you have a range of holidays to exclude =SUMPRODUCT((WEEKDAY(ROW(INDIRECT(start_date&":"&e nd_date)),2)={1,2,3,4})*(COUNTIF(holidays,ROW(INDI RECT(start_date&":"&end_date)))=0)) "Bob Phillips" wrote: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(start_date&":"&end_date)),2) ={1,2,3,4})) -SUMPRODUCT(--(COUNTIF(holidays,(ROW(INDIRECT(start_date&":"&end _date)))*(WEEKDAY(ROW(INDIRECT(start_date&":"&end_ date)),2)={1,2,3,4})))) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Dave" wrote in message ups.com... I know the networkdays automatically calculates the monday to friday routine between two dates. How can I howether compare two dates that doesn't count friday as a workday also, as well as the normal saturday and sunday? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS | Excel Discussion (Misc queries) | |||
networkdays vs days360 | Excel Discussion (Misc queries) | |||
networkdays function help | Excel Worksheet Functions | |||
NETWORKDAYS() not avaialbe after reopening | Excel Worksheet Functions | |||
NETWORKDAYS function problem | Excel Worksheet Functions |