Hi All,

I am working on a workbook that requires prior 3 month average calculations each month for several rows. So lets say its July right now and Apr, May, June numbers are in columns A B and C. When I go into Aug, I want the forumla to calculate the average of B, C and D and so on for each new month.

Can any one help me with how I can make the inputs dynamic, so I dont have to update it each month. Assistance will be greatly appreciated.

Regards,
Sumaira