Formula for pro rate in excel

[alyssajk]

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!

 

[BigBeachBananas]

Beginning versus the end of the month makes a difference. Adjust accordingly. Try this:

Book1
	A	B
1
2	Month Go Live	1/30/22
3	Fiscal Month Starts	10/30/22
4	Monthly Amount	140
5	Annual	1680
6	Pro-rated	1256.547945
Sheet1

Cell Formulas
Range	Formula
B6	B6	=YEARFRAC(B2,B3,3)*12*B4