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

On Mon, 19 Mar 2012 05:44:01 +0000, Benjamin Fleming wrote:


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.