ExcelBanter - weeks in a month

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - weeks in a month (https://www.excelbanter.com/excel-discussion-misc-queries/253732-weeks-month.html)

rk0909

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)

Jacob Skaria

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)

All times are GMT +1. The time now is 06:49 AM.