Number of Saturdays in Month or Given Period

Here are a quick example how to determinate number of Saturdays for month or given period of time with excel formula.

First in one cell, in our example it will be A1, put start time for desired period of time, then in second cell, B1 in our example put end of period.

In some other cell, A4 in our example put formula:
=SUM(INT((WEEKDAY(A2-7)+B2-A2)/7))

And here it is our result! Peace of cake !:)

See picture below for illustration

If it’s easier for you, you can buy and download the finished file with the entered formula
for $10