calculation help for one of requirement

[Are Kaveri]

Hi ,

I have below requirement,

I have field called number of days.

i want it in number of months .

we have a calculation for below.

total interest = number of days(in months) * 0.5*12

I am not understanding how to convert number of days in months.

[Danish Bhairag2 · Accepted solution]

Hi @Are Kaveri ,

To convert days in to month u can just divide the number of days value by 30.44 ( which is basically the average of 12 months)

So it should be like 

var months = number_of_days/30.44

Thanks,

Danish