weeks in a month

R

rk0909

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top