counting weeks in current month.

[Benjamin Fleming]

I am looking for a formula that will count the number of weeks (th
start of which is sunday) in a month. Im hoping it will come out at 4
4.5, or 5 etc... depending on the month. for example, say i spend $10
dollars on a cell phone bill per month. but i want to find out how muc
to set aside per week. I want to divide $100 by the number of weeks i
the current month.
this formula counts the number of days:

=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))
or
=DAY(EOMONTH(TODAY(),0))

can I do this same thing with weeks? please help... t

 

[Ron Rosenfeld]

I am looking for a formula that will count the number of weeks (the
start of which is sunday) in a month. Im hoping it will come out at 4,
4.5, or 5 etc... depending on the month. for example, say i spend $100
dollars on a cell phone bill per month. but i want to find out how much
to set aside per week. I want to divide $100 by the number of weeks in
the current month.
this formula counts the number of days:

=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))
or
=DAY(EOMONTH(TODAY(),0))

can I do this same thing with weeks? please help... ty

You seem to want fractional weeks, so just divide the number of days by seven. The starting day of the week is irrelevant.

If the starting day of the month is not the first, for billing purposes, you will have to tell us when it starts and ends.