How do I do a pro ration calculation in excel
How do I do a proration calculation in excel?
I'd like to take inputs from the user -
Amount to prorate
Starting date - date product purchased
end date - date of failure/warranty claim
base warranty period - period where coverage is 100%
prorated warranty period - Period where warranty is prorated. starts at day one regardless of base period.
Example:
Product is $400
Purchased 12/1/07
Warranty claim 6/1/10
Base Warranty 24months
Prorated period 6 months
$400 is prorated for 30months
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The formula was using dates in A1 and A2. You put yours in A1 and B1. Try moving the date from B1 to A2.
Brad
Brad
ASKER
Thank you very much for your help.
ASKER