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