Counting Weekends between two dates

D

durdle

New Member
Joined
Aug 16, 2004
Messages
18
Good day,

I want to calculate the number of Saturday & Sunday's between two dates. For example in cell A1 I have 27-Feb-07 and in B1 I have 20-Mar-07 ; is there a formula to calculate the difference the number of Weekend days between those two dates. So in this example it would be 6 days as the answer. The weekends I am refering to are Saturday and Sunday.

Thank you for your help,
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Two alternative ways....

using NETWORKDAYS from Analysis ToolPak add-in

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

or without Analysis ToolPak

=SUM(INT((WEEKDAY(A1-{1,7})+B1-A1)/7))
 
Upvote 0
Give this a try

Give this a try
Confirmed with Ctrl + Shift +Enter

=COUNT(IF(WEEKDAY((A1-1)+ROW(INDIRECT(1&":"&(B1-A1+1))),2)>5,1,""))
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
Add 1 day to a date within a range as long as 2 conditions are met [without macros]
Replies
4
Views
562
juanam
J
A
  • Question
Calculate Month End Dates (Weekend dates) based on the previous weekend dates and update values
Replies
3
Views
504
awoohaw
awoohaw
F
  • Locked
  • Question
Formula to count days between 2 dates/times excluding weekends but including only partial days depending on when the date/time falls (see description)
Replies
2
Views
604
Peter_SSs
Peter_SSs
M
  • Question
Complexed Time Difference Formula
2
Replies
17
Views
1K
mahmed1
M
R
  • Solved
Counting months
Replies
3
Views
356
JamesCanale
JamesCanale

Forum statistics

Threads
1,214,789
Messages
6,121,593
Members
449,038
Latest member
Arbind kumar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top