i have a formula field that returns number of months record untouched. For smaller dates (within last 3 years range) it is working fine, if the date exceeds 4 years then result is exceeding a month, which shouldn't be. Any idea is appreciated.
Here is the current logic,
FLOOR(TODAY() - Date__c) / 30.4368