Back Tracking Dates

Lucas Knepper

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? 

Mike Wilday

The formula would look like this if it had a space in the column name:

=[Date column name]1 - 14

If you column did not have spaces then it would look like this: 

=DateColumnName1 - 14. 

Both columns would have to be Date Column types.