Need number of Saturdays and number of Sundays between 2 dates

C

Class316

In excel I use the formula =networkdays(A1,A2) [where A1 and A2 ar
dates] to get the number of weekdays between 2 dates. Is there
formula to get the number of Saturdays and number of Sundays?

So basically there are 2 dates, I need the number of Saturdays betwee
these dates, and another formula for number of Sundays.

Would appreciate any help. Thanks
 
J

Jason Morin

For Saturdays, try:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=7))

For Sundays, change the 7 to a 1.

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference - except for Saturdays and Sundays 10
count work days excluding Fridays and Saturdays ??? 3
No. of Saturdays between 2 dates 5
To find out number of sundays and saturdays in january month 3
Count Weekend Days solutions thank you very much to both of you 0
Number of Saturdays within a range of dates 4
How can I count the number of SATURDAYS in a month? 2
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr 13

Top