Using excel to figure out sales contribution based on date

Hi all, I am trying to figure out how to have excel figure out based on a date I give it figure out one complete year of revenue or sales contribution (quarterly). For example if I buy a gumball machine today and i expect it to generate $10 in 2009 and $12 in 2010. There will 23 days left in the fourth quarter that I will get contribution for in 2009 but i will also get contribution for the first three quarters of 2010 as well as 69 days of contribution in the fourth quarter. Is there a way to automate this? I know I can easily do it manually but if I use a static date I would it to calculate one year of contribution based on a quarterly basis. I have attached an example. Thanks for your help!!!