Formula - multiplication with conversion from months to days

Hello everyone! I want to calculate that in the field “HP ending” will be displayed a date that “X” number of months from “Close Date”. Currently I need to convert months to days so I multiply by 30.43… I am aware it’s not the best solution and I also have the issue where the default state is 30.43 days from Close Date even though I have not entered anything on HP Length. Anyone knows a better workaround and how to do this better?

2

@leonardo

You might want to take a look at using the EDATE() function. It will add (or subtract) months from a given date. This is not documented in monday. You can find out more about this and other undocumented functions here: The monday Hidden Functions – The Monday Man

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