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

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

Answers

  • Mark Cronk
    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!