Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Back Tracking Dates

Lucas Knepper
edited 12/09/19 in Archived 2017 Posts

I am trying to create a formula that can generate a date 2 weeks prior to a set date. For example: 

9/1/17 - 14 days = 8/18/17

I assumed the formula would be as simple as "=[cell w/ given date] - 14" but it will not work and the column is a Date Type.

Any suggestions? 



This discussion has been closed.