How do I calculate the yearly revenue?
I have my sales pipeline in a sheet. It includes the first billing date in format "MM/DD/YY", total billable months and monthly billable amount. How do I calculate the revenue for each year? Most of our contracts are 36 months long. I can't seem to figure out how to pull the revenue for each year. Thank you in advance for your help.
Help Article Resources
Check out the Formula Handbook template!