Date calculations return different results....

Hey ​@KenD,

Please note that MONTH returns the actual number of month of the date. So if MONTH( 8/18/2025)) is August (month 8) and Today is a day of July (month 7), then 8-7 is 1.

On the other hand, the first formula is rounding up to 0 months given that no complete month as passed. (e.g. using months/30 to go from days to months, and handle decimals with Round and formatting)

Depending on your use case and needs, the formula(s) could be further worked on. What do you actually need?

Mike, Consultant @ Automatic Nation

Thank you ​@Mike_AutomaticN, that makes sense. I need the Month() - Month() to determine a count of months between today and the end date.

Thanks again...Ken

You can use ‘days’ / 30 as well, with necessary ROUND precision, if needed (don’t forget to set number of decimal digits in ‘Formatting’).  365/12=30.42 is better.
it’s not 100% accurate, but otherwise you will get 1 month

for 1 day interval between 2025-07-31 and 2025-08-01 

and 0 months for 30 days interval between 2025-08-01 and 2025-08-31

Oh yes ​@KenD when I said months/30 I actually meant days/30.

In short, the formula you will want to use is the following:
 

DATETIME_DIFF({Date}, TODAY(), "days")/30

You will want to set the formatting to include decimals for sure -see screenshot below.
 

Not really needed I believe, but you could also have your formula include the rounding, as shown below:

​​​​​​

ROUND(DATETIME_DIFF({Date}, TODAY(), "days")/30, 2)

Feel free to grab a slot if you need any help. I’d be happy to show you around!

Mike, Consultant @ Automatic Nation

Decided to record a brief YouTube video on this matter. You can check it out below!
 

FYI, in this other post I’ve included some additional details as well as a different -but related- video on how to trigger automations based on this date time calculations :D. Just in case it helps.

Mike, Consultant @ Automatic Nation