Hello

Thanks in advance for any help. I have data on a worksheet (Sheet1) as attached and would like to calculate the following (layout on Sheet2):
-YTD Sales for each year (as a running total)
-MTD Sales for each year (as a running total)

but to show by both:
-Year on Year as being the same dates. So for example upto 09/04 of each year.
-Year on Year as comparable dates. so for example upto 09/04/2013, 10/04/2012, 12/04/2011..... (think this would be week numbers)

Thanks once again.

BigAlex

excel data.xlsx