I’m trying to get the number of months remaining between an end date and today, as a whole integer. The specific use case is for monthly payments that occur during a month. By way of example, today is July 25th, and my end date is October 1, and the result i’d like to see is 4, eg, July, August, September, October.
i am close using this formula, but it’s not correct, as it’s displaying the daycount difference as a # of months. To use my example above, i’d get a result of 3, or possibly even 2.
DATETIME_DIFF(LastDate, TODAY(), ‘months’)
Is there a way to show LastDate as a month# and today as a month # and then the difference between them, even when last date may be 1-2 years in future? eg, if last date is July 1 2020, and today is July 25th, i need the result to be 13, and not 0 (7-7=0)
Any help is appreciated