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!
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!