| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Nearest and Furthest Date
My data table is like so. My date format is YY/M
Today 7-Aug Stock Date SPY 7-Oct SPY 7-Dec SPY 10-Dec OIH 7-Aug OIH 9-Jan Trying to create this table. Basically I am trying to find the date in the data table that is the closest and furthest away from today's date. DateMax DateMin SPY 10-Dec 7-Oct OIH 9-Jan 7-Aug Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding nearest match from an array | Excel Discussion (Misc queries) | |||
| Find the nearest Christmas to a date | Excel Worksheet Functions | |||
| how do I deduct furthest south cell from furthest north cell? | Excel Discussion (Misc queries) | |||
| finding a date/time in a list that is closest to an existing date/ | Excel Discussion (Misc queries) | |||
| How do I select the nearest date from a ranges of dates? | Excel Discussion (Misc queries) | |||
Threaded Mode
