View Single Post
  #1   Report Post  
Benjamin Fleming Benjamin Fleming is offline
Junior Member
 
Posts: 1
Smile 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