How can I add a formula that combines a number of days in varying months to a start date

Mel Webster

How can I get a start date to add in a number of days in month(s) formula (below). I am trying to get to an end date adding in how many months it will take (only the start date and # of months can be changed).

=[# of Months]@row * 30.4375

Mark Cronk

It's not going to be exact but this will get you close. Put this formula in your end date column.:

=[start date]@row + ([# of Months]@row * 30.4375)

Mel