how to include saturdays in networkdays formula
 

Please let me know how to include saturdays in networkdays formula

how to include saturdays in networkdays formula
 

Instead of Monday?

=NETWORKDAYS(start_date-1,end_date-1)

Including Mondays (i.e. 6 day week)

=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Vishnu" wrote in message
...
Please let me know how to include saturdays in networkdays formula

how to include saturdays in networkdays formula
 

=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))

What about those pesky holidays? <g

Biff

"Bob Phillips" wrote in message
...
Instead of Monday?

=NETWORKDAYS(start_date-1,end_date-1)

Including Mondays (i.e. 6 day week)

=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Vishnu" wrote in message
...
Please let me know how to include saturdays in networkdays formula

how to include saturdays in networkdays formula
 

If he wants them I will show him, but until he asks ...

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"T. Valko" wrote in message
...
=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))

What about those pesky holidays? <g

Biff

"Bob Phillips" wrote in message
...
Instead of Monday?

=NETWORKDAYS(start_date-1,end_date-1)

Including Mondays (i.e. 6 day week)

=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Vishnu" wrote in message
...
Please let me know how to include saturdays in networkdays formula

how to include saturdays in networkdays formula
 

Hello Biff,

Does that work?

If start date is 1st December 2006 and end date 31st December 2006 result
should be 27 but that formula gives me 26. With start date in A1 and end date
in B1 I'd use

=B1-A1+1-INT((WEEKDAY(A1-1)+B1-A1)/7)

"T. Valko" wrote:

=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))

What about those pesky holidays? <g

Biff

"Bob Phillips" wrote in message
...
Instead of Monday?

=NETWORKDAYS(start_date-1,end_date-1)

Including Mondays (i.e. 6 day week)

=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Vishnu" wrote in message
...
Please let me know how to include saturdays in networkdays formula

how to include saturdays in networkdays formula
 

Sorry, it must be too late for me!

I should have addressed that query to Bob and I also should have said that
for my example I get 27 using Bob's formula when it should be 26.......

"daddylonglegs" wrote:

Hello Biff,

Does that work?

If start date is 1st December 2006 and end date 31st December 2006 result
should be 27 but that formula gives me 26. With start date in A1 and end date
in B1 I'd use

=B1-A1+1-INT((WEEKDAY(A1-1)+B1-A1)/7)

"T. Valko" wrote:

=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))

What about those pesky holidays? <g

Biff

"Bob Phillips" wrote in message
...
Instead of Monday?

=NETWORKDAYS(start_date-1,end_date-1)

Including Mondays (i.e. 6 day week)

=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Vishnu" wrote in message
...
Please let me know how to include saturdays in networkdays formula