Formula to calculate 1 month from given date



I am trying to count one month from a particular date and need help with the formula.

for example the move in date is 7/29/2022 I want Smartsheet to automatically count 1 month from that date as the due date in a separate column? how do i go about doing that?



  • SolutionSal

    Hello, Smartsheet allows you to calculate dates using formulas. You could use a nested IF statement to calculate approximate move out date like this.

    =IF([Approximate Duration of Stay]@row = "1 Month", [Approx. Move In Date]@row + 30, IF([Approximate Duration of Stay]@row = "2 Weeks", [Approx. Move In Date]@row + 14, "NA"))

    This will work best if you use a Multiselect Column to limit potential values of [Approximate Duration of Stay] to those included in the nested IF formula. Here is a link to a related Help article.

    Hope this helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!