Re: How can I count the number of SATURDAYS in a month?

Z

zxcv

So many posts on excluding weekends via the NETWORKDAYS and WEEKDAY
functions, but how can I get the amount of Saturdays?

Thanks:)
Click to expand...

If your start date is in A1 and end date is in B1 the following will
calculate the number of Saturdays in this range:

=IF((7)<WEEKDAY(A1),CEILING(MAX((WEEKDAY(A1)+(B1-A1)-(7)-6)/7,0),
1),CEILING(MAX((WEEKDAY(A1)+(B1-A1)-(7)+1)/7,0),1))

To check other days change the (7)'s to the corresponding day of the
week (Sun-Fri :: (1)-(6))
 

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

Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr 13
Formula to get number of days excluding Fridays in a given period 17
Sequence of Weeks in a month 8
to find out number off offdays of each employee 1
Calculating how many Saturdays there are between two given dates 6
Need number of Saturdays and number of Sundays between 2 dates 1
Include Saturday in the WORKDAY function 9
To find out number of sundays and saturdays in january month 3

Top