# Formula to calculate 1 month from given date

Options

Hello,

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?

Tags:

• Employee
Options

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!