| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get max & min dates from column
Column "D" has random date values in cells
I need to retrieve the min and max dates from this column and store values in a varible. I have tried the following: Dim d1 As Date Application.Min (Application.Index(d1, 0, 4)) '4=column D This just returns a time stamp |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert column of dates to Hebrew dates | Excel Discussion (Misc queries) | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| How to count dates in a column between 2 dates | Excel Programming | |||
| How do I sum #s in a column based on dates in another column | Excel Discussion (Misc queries) | |||
| Formula help for counting,with a column of dates and a column of n | Excel Worksheet Functions | |||
Threaded Mode
