How to Calculate number of months from Today to an End Date

Willie Tsui

Is there any advice on how to calculate the no. of months between Today and an End Date (mostly likely not in the same year)?

Mark Cronk

HI @Willie Tsui

Try =Round(NETDAYS([end date]@row, today())/ 30.436875)

Mark

Mark Cronk

HI @Willie Tsui

Try =Round(NETDAYS([end date]@row, today())/ 30.436875)

Mark

Willie Tsui

Thank you Mark! It helps.