calculating dates prior to a given date

[Eric]

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.

 

[Pete_UK]

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