Count how many Fridays based on the current day of the month

Please type A24 = today()
F24
=NETWORKDAYS.INTL(EOMONTH(A24,-1)+1,A24-WEEKDAY(A24)+7,"1111011")

Then change A24 to other date to check.

Originally Posted by Special-K

"If the October calendar, there is two Friday in two weeks, Oct. 4 and Oct 12"

According to your calendar October 4th is a THURSDAY not Friday.

Typo, Oct 4 should be Oct 5 which is Friday

Originally Posted by Bo_Ry

Please type A24 = today()
F24
=NETWORKDAYS.INTL(EOMONTH(A24,-1)+1,A24-WEEKDAY(A24)+7,"1111011")

Then change A24 to other date to check.

It works. I make a mistake on my request after I play around with your formula.

If the customers' payment is due weekly between Monday to Friday in that week,
Saturday and Sunday should be the same week as Monday to Friday.

I should set Monday is the first day of the week, and Sunday is the last day of the week not first
day of following week.

Example: If I have a date of Oct. 14 Sunday, the current formula give 3 Fridays. I want to change
to 2 Fridays to make Sunday is the last day of the week.

Thanks

Try this

=NETWORKDAYS.INTL(EOMONTH(A24,-1)+1,A24,"1111011")

I'm not clear on how you count, please give answer on date form Oct below which date give 2 weeks and which data give 3 weeks.

14 15 16 17 18 19 20

Hi,
Your formula gives 1 week when the date is Oct. 10. I need the week for Oct 10 to be 2
because Oct. 10 is within Oct. 8 - Oct 14.

I add the week below the date; I also add Oct. 21 Sunday to show it belongs to 3th week. Thanks

14 15 16 17 18 19 20 21
2 3 3 3 3 3 3 3

Ok this should work

=NETWORKDAYS.INTL(EOMONTH(A24,-1)+1,A24-WEEKDAY(A24,2)+7,"1111011")

Hi,
Indeed it does work what I want. Thanks a lot!