| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
find most recent date in a row
You're the King! Thanks so much for your help!
"Jacob Skaria" wrote: =IF(COUNT(A2:C2)=0,"",MAX(A2:C2)) If this post helps click Yes --------------- Jacob Skaria "Marge" wrote: Great! And if A, B and C are all blank, how can I tell D to be blank also? "Jacob Skaria" wrote: =MAX(A2:C2) and format cell to date If this post helps click Yes --------------- Jacob Skaria "Marge" wrote: I have columns similar to these (the dates represent project completion dates): A B C blue team OK red team OK white team OK 4/5/09 5/7/09 6/27/09 In column D I want to enter the most recent of the A, B and C dates. If the dates were in columns instead of rows I could filter for the most recent....how can I "filter" across a row? Thanks for any help you can offer! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the most recent date | Excel Discussion (Misc queries) | |||
| How to find the most recent date in a column based on other column | Excel Worksheet Functions | |||
| date function to find most recent order | Excel Worksheet Functions | |||
| Find most recent date | Excel Worksheet Functions | |||
| Find most recent date in a row of dates | Excel Discussion (Misc queries) | |||
Threaded Mode
