| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working from oldest date
Hello Biff,
Why not simply: A10: =INDEX(B1:B2,1+($A1$A2)) A11: =INDEX(B1:B2,1+($A1<=$A2)) Copied across to B10:B11 :-) ....Yeah, that'll work :-) Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Substracting from oldest date | Excel Discussion (Misc queries) | |||
| Finding the oldest date in a column | Excel Worksheet Functions | |||
| Find Oldest Date | Excel Discussion (Misc queries) | |||
| oldest date not completed | Excel Worksheet Functions | |||
| Detecting Oldest Date On Spreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
