| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Columns for Most Recent Date
I have a bunch of columns (below). I want to write the VBA to search
all the date columns and then display the most recent date in another column. Columns: Firm Name Date 1 Meeting Type Date 2 Meeting Type Date 3 Meeting Type Date of Last meeting XYZ Smith 1/1/91 Lunch 2/1/01 Dinner 3/1/08 Conference 3/1/08 ABC Joe 12/31/07 Call 1/15/08 Lunch 2/29/08 Dinner 2/29/08 Thanks for your help. Scott |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Search Columns for Most Recent Date
Use the MAX function on your dates, you dont need to do in VBA, but you can.
"Scott Halper" wrote: I have a bunch of columns (below). I want to write the VBA to search all the date columns and then display the most recent date in another column. Columns: Firm Name Date 1 Meeting Type Date 2 Meeting Type Date 3 Meeting Type Date of Last meeting XYZ Smith 1/1/91 Lunch 2/1/01 Dinner 3/1/08 Conference 3/1/08 ABC Joe 12/31/07 Call 1/15/08 Lunch 2/29/08 Dinner 2/29/08 Thanks for your help. Scott |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Four columns excel showing dates fifth shows most recent | Excel Discussion (Misc queries) | |||
| most recent date | Excel Discussion (Misc queries) | |||
| Most Recent Date and unique name | Excel Programming | |||
| Looking up the most recent date | Excel Worksheet Functions | |||
| Search for most recent date from list of dates | Excel Discussion (Misc queries) | |||
Linear Mode
