Hello Community!
Is there a way to calculate the number of complete months between two dates in Anaplan?
E.g.
Start Date (MM/DD/YYYY) | End Date (MM/DD/YYYY) | Number of Complete Months |
07/17/2020 | 07/16/2021 | 12 |
12/03/2021 | 03/31/2022 | 3 |
10/1/2021 | 12/31/2021 | 3 |
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.
Thanks.