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?
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: https://themondayman.com/hidden
