Calculate the number of complete months between two dates (Similar to Excel DATEDIF Function)
Is there a way to calculate the number of complete months between two dates in Anaplan?
|Start Date (MM/DD/YYYY)||End Date (MM/DD/YYYY)||Number of Complete Months|
In the second row, even though the duration between 12/03/2021 & 03/31/2022 is 3 months, 29 days - the system should return 3 as the number of complete months.
Any help on the best way to solve this would be appreciated.