Formula for pro rate in excel

alyssajk

New Member
Hi there,

I would like to have a formula so that when I enter the date of go live, it will calculate the pro rated amount?

Example: go live in Jan
Monthly: \$140.00 (to be pro-rated)
Annual: \$1680
Pro-rated base on go live
Fiscal Year starts in Oct.

Usually I will just enter =\$140*9 = \$1260

Is there a way I can make a formula instead?

Thank you!

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

BigBeachBananas

Board Regular
Beginning versus the end of the month makes a difference. Adjust accordingly. Try this:
Book1
AB
1
2Month Go Live1/30/22
3Fiscal Month Starts10/30/22
4Monthly Amount140
5Annual1680
6Pro-rated 1256.547945
Sheet1
Cell Formulas
RangeFormula
B6B6=YEARFRAC(B2,B3,3)*12*B4

Replies
0
Views
106
Replies
1
Views
88
Replies
1
Views
82
Replies
1
Views
38
Replies
6
Views
190

1,191,043
Messages
5,984,321
Members
439,882
Latest member
gerdc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back