Hi All,

I am looking for formula that would help me in converting weekly data to monthly data. The only solution I can think of is divide the week's data by 7 and then multiple it with days of month. But problem is whole month's data will be based on one week's data.

How can I convert weekly data to monthly that will also consider the weeks starting at the end of month.

Hope you understand what I am trying to ask here ...

Cheers,