#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,726
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 174
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
NETWORKDAYS Compute Excel Discussion (Misc queries) 1 November 26th 06 01:56 AM
networkdays vs days360 Toothfaerie Excel Discussion (Misc queries) 1 May 31st 06 02:56 AM
networkdays function help Deb Bagby Excel Worksheet Functions 3 November 1st 05 06:36 PM
NETWORKDAYS() not avaialbe after reopening Stan Excel Worksheet Functions 2 June 19th 05 04:53 PM
NETWORKDAYS function problem Arvi Laanemets Excel Worksheet Functions 5 April 19th 05 08:10 AM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"