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!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using excel to figure out sales contribution based on date
- Thread starter kidnos
- Start date
- Thread starter
- #2
I forgot to mention that the date in my post is not accurate, there are currently 17 days left in the quarter, my bad. Actually, now that I think about is there a way to pull number of "working days" in the quarter? I think that could be more applicable than just days in the quarter.
Thanks again.
Thanks again.
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question