# Formula to generate date 1 year from today?

Options

I am trying to figure out a formula that will generate a date that is 1 year from today.

For example, if we have a contract that requires 12 months of notice to cancel, and I have a column to track the Earliest Possible Termination Date, I want that column to tell me the date that is 1 year out, or 365 days after today.

Tags:

• ✭✭✭✭✭✭
Options

I would suggest using a column that has the contract start date and use that static date to determine 1 year later. There is a TODAY() formula that can be used but it will continually change your value as "today" changes.

So, the Earliest Possible Termination Date column could use the following column formula.

=[Contract Start Date]@row + 365

Hope this helps,

Dave

• Options

Hi @DKazatsky2, thank you for your response! I am very interested in learning the TODAY() formula that will continually change value as "today" changes -- that's actually what I'm needing to accomplish in my sheet. Could you please share how you'd use that formula?

• ✭✭✭✭✭✭
Options

All you need to do is use TODAY() in any formula. So to get the date in one year you would use =TODAY() + 365.

Best of luck,

Dave

• Options

=DATE(YEAR(TODAY())+1, MONTH(TODAY()), DAY(TODAY()))

This way is a little more flexible, can do with months or days too but here you have format to do any.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!