| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
weeks in a month
I want to calculate total weeks between two dates.
Complexity is that we have a defined number of weeks in a month as follows July Aug Sep Oct Nov dec Jan Feb Mar Apr May Jun 4 4 5 4 4 5 4 4 5 4 4 5 E.g.s Start date End Date Req. Answer (Cum Weeks) Jan'09 Mar'09 13 Dec'09 Mar'10 18 Aug'09 Sep'10 61 (One full year + 9 weeks for Aug'10 and Sep'10) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
weeks in a month
With dates in A2 and B2 try
=ROUNDUP(DATEDIF(A2,B2,"d")/7,0) -- Jacob "rk0909" wrote: I want to calculate total weeks between two dates. Complexity is that we have a defined number of weeks in a month as follows July Aug Sep Oct Nov dec Jan Feb Mar Apr May Jun 4 4 5 4 4 5 4 4 5 4 4 5 E.g.s Start date End Date Req. Answer (Cum Weeks) Jan'09 Mar'09 13 Dec'09 Mar'10 18 Aug'09 Sep'10 61 (One full year + 9 weeks for Aug'10 and Sep'10) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you calculate the number of weeks on a month | Excel Discussion (Misc queries) | |||
| Identifing Weeks in a Month. | Excel Discussion (Misc queries) | |||
| Help Please: Need an Average for 16 Weeks according to Month | Excel Worksheet Functions | |||
| Sequence of Weeks in a month | Excel Worksheet Functions | |||
| Sum data for weeks in a month | Excel Discussion (Misc queries) | |||
Linear Mode
