How to calculate weekly and Monthly Run Rate

[yakhtar]

Can someone tell me how to calculate run rate in Excel?

I would like to find revenue based on run rate for the week and for the month and compare it to previous week and previous month.

The revenue data is imported into Excel every day.

I have one row with last year's revenue by month
I have one row with monthly target.
I also have this year's revenue as of a few days ago by month (so far Jan, Feb and 5 days in March)

I would like to see how we are doing compared to the monthly target
I would like to see how we are doing again compared to same month last year


I would like to see how we are doing compared to last month
I would like to see how we are doing this week compared to last week

Your help would be greatly appreciated.

[jeffreybrown]

Cross-posted at: http://www.excelforum.com/excel-gene...-run-rate.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184