Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Number Of Weekdays Between Two Dates

1. Six Strings Guest

## Number Of Weekdays Between Two Dates

Here is a formula to calculate the number of weekdays between two dates, inclusive. That is, the number of weekdays between Monday and the next day are 2. I am using this for a schedule spreadsheet where I need to see working days.

In this example, cell A2 contains the earlier date and B2 contains the later date.

=MAX(WEEKDAY(B2,2)-WEEKDAY(A2,2),0)+1+INT((B2-A2)/7)*5

If you don't want it to be inclusive you can remove "+1".

This, of course, does not take holidays into account.

Excel Video Tutorials / Excel Dashboards Reports

2. Super Moderator
Join Date
26th January 2003
Location
Derbyshire,UK
Posts
19,833

## Re: Number Of Weekdays Between Two Dates

Thanks for sharing

3. ## Re: Number Of Weekdays Between Two Dates

Formula doesn't work, though

A2 = Friday 11th May 2007
B2 = Tuesday 15th May 2007

formula gives a result of 1

For a count of weekdays between two dates without using NETWORKDAYS

=SUM(INT((WEEKDAY(A2-{2,3,4,5,6})+B2-A2)/7))

Excel Video Tutorials / Excel Dashboards Reports

4. Highly Valued Member
Join Date
26th January 2003
Location
UK
Posts
4,635

## Re: Number Of Weekdays Between Two Dates

Intresting - jiuk uses NETWORKDAYS even in Access I use NETWORKDAYS. Will have to remember to test these next week in my real work so Jack can test and compaire

jiuk

Excel Video Tutorials / Excel Dashboards Reports

5. Six Strings Guest

## Re: Number Of Weekdays Between Two Dates

I found some time after posting that this didn't work. I developed a formula that does work, though it's rather complex. If anybody really wants to see it I'll pull it out of the junk drawer.

Then I discovered the NETWORKDAYS function and figured there was no point in continuing to post updates to this thread.

Excel Video Tutorials / Excel Dashboards Reports

##### Users Browsing this Thread

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