| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return the greatest value in a range of cells
I have a list of dates and I want a function that will return the latest date
in the list. Is such a thing possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
return the greatest value in a range of cells
be sure the cells are formatted as dates, then use the formula "=MAX(range)".
"Jen" wrote: I have a list of dates and I want a function that will return the latest date in the list. Is such a thing possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
return the greatest value in a range of cells
Check out Excel help for the MAX function.
On Thu, 29 Oct 2009 11:12:01 -0700, Jen wrote: I have a list of dates and I want a function that will return the latest date in the list. Is such a thing possible? Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
return the greatest value in a range of cells
Great! Thanks for the swift reply. :)
"Mike" wrote: be sure the cells are formatted as dates, then use the formula "=MAX(range)". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| See if a range of cells contains certain text to return the value | Excel Worksheet Functions | |||
| Retun greatest # of cells between nonzero | Excel Discussion (Misc queries) | |||
| Greatest difference between a consecutive range of dates | Excel Discussion (Misc queries) | |||
| Return A Range of All Cells With Links | Excel Worksheet Functions | |||
| lookup and return range of cells | Excel Worksheet Functions | |||
Linear Mode
