Count the number of Saturdays that have passed in a month so far

[Badvgood]

Morning All,

The month start date is in cell D1

I need a formula that will calculate the number of Saturdays that have passed so far in the month based on todays date.

I have worked out the one to get weekdays but not Saturdays!

=NETWORKDAYS(D1,TODAY()-1)

Thanks in advance

[Fotis1991]

Good morning to you too.

Try this.

Please Login or Register  to view this content.

Assuming that your system counts Saturday as the 7th day of the week.

[Badvgood]

Thanks for the prompt reply.

It does not seem to like that...

error.jpg

[Fotis1991]

Pictures are nice but workbooks are better!!

[Badvgood]

Perfect, thank you. Duly noted about pictures and workbooks.

[Fotis1991]

You are welcome and thanks for the feedback & rep.

[daddylonglegs]

=INT((TODAY()-(D1 + INDEX({6\5\4\3\2\1\0},WEEKDAY(D1,2))) + 1)/7) + 1

Does this work? If I put last Sunday's date in D1, then because today is Friday I expect the answer 0 because there are no Saturdays in that range, but I get 1

I'd use this formula

=INT((WEEKDAY(D1)+TODAY()-D1)/7)

[Fotis1991]

Does this work? If I put last Sunday's date in D1, then because today is Friday I expect the answer 0 because there are no Saturdays in that range, but I get 1

But i think the question was for something else.

The month start date is in cell D1

I need a formula that will calculate the number of Saturdays that have passed so far in the month based on todays date.

Unless my English are so bad..and Op just thought that got the correct answer!!

[daddylonglegs]

But i think the question was for something else.

OK, but in the workbook you posted D1 has a date and isn't the formula supposed to calculate the number of Saturdays from that date until today? Counting Saturdays from the start of the month until today would just be a specific example of that.

If today is 14th June 2014 and D1 contains the 1st of that month, 1-Jun-2014, then your suggested formula gives the result 3......but there are only 2 Saturdays in that range

[Fotis1991]

OK, but in the workbook you posted D1 has a date and isn't the formula supposed to calculate the number of Saturdays from that date until today? Counting Saturdays from the start of the month until today would just be a specific example of that.

Exactly. In my Example D1 has the date 01/01/2014 and result as 11, using the formula that i suggested.I tested also using 01/02/2014 and 01/03/2014 and posted it.

Of course you are correct with your example of 14/06/2014.