Find months between two dates

Hello,

I’m trying to calculate the number of months between two dates. I tried the days formula and have issues with that also. Thank you1

@ttran3

One way is to use the undocumented function YEARFRAC():

YEARFRAC({Start Date}, {End Date}) * 12

You can find out more about this and other undocumented functions here: monday hidden functions

Jim - Subscribe to The Monday Man
Watch Our Latest Video: Quick Tip - The Trick to Editing Custom Automations

you are a lifesaver. thank you

@ttran3

You are very welcome.

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday.com Mirror Columns in Integromat - the Basics
Check out our monday apps, now in beta: The Monday Man Apps