Is it possible to prorate normalization amounts according to the days in a month?

Hi,

There is an ask from business if following is possible: (an example)

Total Rent Amount: 12000 (USD)

Rent Period: 12 months

Calculation of normalized entry should be as per the last column 'Prorated Amount on the basis of days in a month'.

  

Month	Monthy Normalized Amount	Number of Days in a month	Formula	Prorated Amount on the basis of  days in a month
Jan-17	1000	31	=(12000/365)*31	1019.178
Feb-17	1000	28	=(12000/365)*28	920.5479
Mar-17	1000	31	=(12000/365)*31	1019.178
Apr-17	1000	30	=(12000/365)*30	986.3014
May-17	1000	31	=(12000/365)*31	1019.178
Jun-17	1000	30	=(12000/365)*30	986.3014
Jul-17	1000	31	=(12000/365)*31	1019.178
Aug-17	1000	31	=(12000/365)*31	1019.178
Sep-17	1000	30	=(12000/365)*30	986.3014
Oct-17	1000	31	=(12000/365)*31	1019.178
Nov-17	1000	30	=(12000/365)*30	986.3014
Dec-17	1000	31	=(12000/365)*31	1019.178
Total	12000	365		12000