Year on Year data review compared to todays date

Hi

Looking to do some data analysis using fomulas if possible. I want to be able to give the last 3 months total revenues compared to the same 3 months in the previous year. That is easy enough from a static time but I want to be able to show the results based on the current date. I have attached a spread sheet to show this.

Thanksdata.xlsx

Thanks for the response. That looks fine apart from it does not seem to work across years. for example if the current date is January then it does not go back 3 months into the previous year.

data.xlsxHi sorry to mess you around but it is not doing quite what I need it to I don't think. I want it to work whatever date and year you enter both historically and in the future. See attached file with multiple years of data.

thanks very much that is perfect.