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

  • Thread starter Thread starter zxcv
  • Start date Start date
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))
 
Back
Top