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
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
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
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.