If you have a date in A1 and you want another date in B1 which is 14
days earlier, then put this in B1:

=A1-14

Copy this formula down, then fix the values by selecting all those
cells with the formula in, clicking on <copy, then right-click and
Paste Special | Values (check) | OK then <Esc.

Insert a new column B, then sort column C, then delete column B.

Hope this helps.

Pete

On Dec 15, 7:59*pm, Eric wrote:
Hi. I am trying create a spreadsheet that will have dates listed in one
column and have another column list the date 14 days prior to the first
column's dates. *I'm hoping to then organize the second column ascending from
the closest *to the furthest date, compared to the current date. *If anyone
has any help they could provide it would be much appreciated. Thank You.