Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
weeks in a month | Excel Discussion (Misc queries) | |||
current week, current month, current year | Excel Programming | |||
How do I count the number of even weeks in the current month. | Excel Worksheet Functions | |||
Number of weeks past in current qtr | Excel Worksheet Functions | |||
copy worksheet from previous month and rename to current month | Excel Programming |