Services Calculator
Project detail
Goal:
1. To have a spreadsheet that calculates how much I need to charge my customer on a per month or annual basis.
2. If the customer initially purchases 1 x backup service on 25/2/2020 for $50/month and then purchases 2 or more backup services on 25/6/2020 for the same price of $50/month, I need a calculator that to show me how much I need charge them per month or per year based on the subscription start date?
There should also be a cell that adds a setup fee of $50/domain.
*I also need to improve on my Excel skills and would appreciate if you are able to talk through the formula’s used.
This will be a rather easy project for someone who knows Excel. If you have any questions please feel free to ask.
Thx.