calculating dates prior to a given date

  • Thread starter Thread starter Eric
  • Start date Start date
E

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.
 
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
 
Back
Top