Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Date Difference Without Weekends

1. Member
Join Date
3rd December 2004
Posts
30

## Date Difference Without Weekends

Good day,

I have searched google and many forums and cannot find out what formula I can use to calculate the difference between two dates while not including weekends. For example in cell A1 I have 27-Feb-07 and in B1 I have 05-Mar-07 ; it is possible to to calculate the difference between these by not including weekends. The weekends I am refering to are Saturday and Sunday.

Chris

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Date Difference Without Weekends

Yes... special function in Excel called:

NETWORKDAYS

use like =Networkdays(Start,Finish,Any Holidays)

You must add the "Analysis Tool Pak" to access this function (from the Tools/Add-in Manager).

Ger
Last edited by Ger Plante; March 15th, 2007 at 23:27.

3. Member
Join Date
3rd December 2004
Posts
30

## Re: Date Difference Without Weekends

I enter =Networkdays(B135,C135) in the cell and received the #Name? message. Do you have to enter the "Any Holidays" section although there isn't any?

Thank you,

Excel Video Tutorials / Excel Dashboards Reports

4. ## Re: Date Difference Without Weekends

Like I said - you MUST have the Analysis Tool Pak added in...

Go to Tools/Add-In and check to make sure "Analysis ToolPak" is there.

Ger

5. ## Re: Date Difference Without Weekends

Check also to make sure the two cells that are references are valid dates and formatted as a date.

Thanks,
Ger

6. Member
Join Date
3rd December 2004
Posts
30

## Re: Date Difference Without Weekends

If you have 27-Feb-07 in A1 and in B1 you have 05-Mar-07 , wouldn't the differene be 4, considering the DateDiff function between those dates are 6? Because the networkdays function is giving me 5.

Excel Video Tutorials / Excel Dashboards Reports

7. ## Re: Date Difference Without Weekends

Well... whats a day between friends

Seriously, the Networkdays function counts the first day as a date...

if start date and end date are the same (27 Feb), it will return 1, whereas you might expect it to be zero.

In otherwords, its an inlclusive function.

Ger
Last edited by Ger Plante; March 15th, 2007 at 23:44.

8. Member
Join Date
3rd December 2004
Posts
30

## Re: Date Difference Without Weekends

Makes sense.

Thank you.

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno