Formula to calculate difference between the settlement date of a property and current date in decimal format

Formula to calculate difference between the settlement date of a property and current date in decimal format

Hi I'm seeking help to create a formula which I just don't seem to be able to figure out how to do in the Zoho system.

I typically do this in Excel and am essentially looking to calculate the difference between the settlement date of a property which I have as a custom field and today's date as a decimal figure.

 For Example I can do this in Excel using a formula such as:

=((YEAR(CurrentDateCell)-YEAR(SettlementDateCell))*12+MONTH(CurrentDateCell)-MONTH(SettlementDateCell))/12

 If I had the below values as the Settlement Date and Current Date it would return a decimal value of 20.25 which is what I'm after but I can't find a way to replicate this in Zoho.

Settlement Date: 22/08/2001

Current Date: 13/11/2021

Sample Excel file attached for reference.

Thanks for any assistance!