I have weekly data in a sheet. Obviously, weeks can span across months e.g. week of 28 Jan 2008 is having Fri, Sat and Sun falling on Feb 1,2,3. What I want is to *accurately* convert that weekly data pro-rata basis into monthly data (1st of Month thru last calendar day of that month). I am able to do approximation but that not accurately..
Please see attached xls sheet (zipped)
Bookmarks