Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find most recent date
Is there a function that returns the most recent date from a list, or group,
of dates (the dates are in random order)? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find most recent date
Hi Andi
Try =MAX(A1:A100) Change range to suit where your dates are held -- Regards Roger Govier "Andi Sea" <Andi wrote in message ... Is there a function that returns the most recent date from a list, or group, of dates (the dates are in random order)? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find most recent date
use =MAX() -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=550160 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How to return a value between date ranges | Excel Worksheet Functions | |||
Need help to find a date (latest date) from a column | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Find Max after a date | Excel Worksheet Functions |