Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating dates prior to a given date
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating dates prior to a given date
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating number of prior pay periods in year when given specificdate. | Excel Worksheet Functions | |||
Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
Entering Dates for a Prior Year | Excel Discussion (Misc queries) | |||
dates, 1 month prior | Excel Worksheet Functions | |||
Dates prior to 1900 | Excel Worksheet Functions |