| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Minimum and maximum date lookup
=TEXT(MIN(A1:A29),"dd-mm-yyyy")&" - "&TEXT(MAX(A1:A29),"dd-mm-yyyy")
-- Kind regards, Niek Otten Microsoft MVP - Excel "Michael Peace" <Michael wrote in message ... |I want to make a cell display the earliest, and/or latest date in a list of | dates in a column. That way I can have a cell show the date range of a list | of dates from the earliest to the latest. I'm a rookie at Excel, I know just | enough to get me into trouble. Can anyone help me with this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula with minimum & maximum values | Excel Worksheet Functions | |||
| maximum/minimum value in formula | Excel Discussion (Misc queries) | |||
| Finding a maximum/minimum date in 2006 | Excel Discussion (Misc queries) | |||
| Spinners - minimum and maximum | Excel Discussion (Misc queries) | |||
| Maximum and minimum cell value | Excel Discussion (Misc queries) | |||
Threaded Mode
