counting weeks in current month.
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
|