Non working days
 

Is there a formula to calculate the number of non working days between 2
specific dates. For example:

01-01-07 to 31-01-07

No. of Saturdays = 4
No. of Sundays = 4

Cheers

Non working days
 

Put your dates in A1 and B1 and try this formatted as general

=DATEDIF(A1,B1,"d")-NETWORKDAYS(A1,B1)

Mike

"The Rook" wrote:

Is there a formula to calculate the number of non working days between 2
specific dates. For example:

01-01-07 to 31-01-07

No. of Saturdays = 4
No. of Sundays = 4

Cheers

Non working days
 

Sorry, I should have added that because you want 'between' 2 dates the
earlier date must be moved 1 day back. i.e. in this example 31/12/2006.

Mike

"The Rook" wrote:

Is there a formula to calculate the number of non working days between 2
specific dates. For example:

01-01-07 to 31-01-07

No. of Saturdays = 4
No. of Sundays = 4

Cheers

Non working days
 

Also no need to use DateDif, just B1-A1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mike" wrote in message
...
Sorry, I should have added that because you want 'between' 2 dates the
earlier date must be moved 1 day back. i.e. in this example 31/12/2006.

Mike

"The Rook" wrote:

Is there a formula to calculate the number of non working days between 2
specific dates. For example:

01-01-07 to 31-01-07

No. of Saturdays = 4
No. of Sundays = 4

Cheers

Non working days
 

I think you'd need this formula

=B1-A1+1-NETWORKDAYS(A1,B1)

Although NETWORKDAYS is part of Analysis ToolPak add-in. If you want to
avoid using Analysis ToolPak functions

=SUM(INT((WEEKDAY(A1-{1,7})+B1-A1)/7))


"Bob Phillips" wrote:

Also no need to use DateDif, just B1-A1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mike" wrote in message
...
Sorry, I should have added that because you want 'between' 2 dates the
earlier date must be moved 1 day back. i.e. in this example 31/12/2006.

Mike

"The Rook" wrote:

Is there a formula to calculate the number of non working days between 2
specific dates. For example:

01-01-07 to 31-01-07

No. of Saturdays = 4
No. of Sundays = 4

Cheers