max date

C

ceemo

i have in column A:A a various list of dates in the following format

12/08/2006 Saturday

I want to create a list of the available months in column A:A to use in
a drop down menu.

This is a general format so ive not been ale to go for the max numeric
value although i can do a datevalue function(leftx,5)) to get the value
and then find the max date but this causes the workbook to slow as i
would have to run this against 9 imported worksheets. Also the rows
used vary on different imported time ranges.

As the dates are in acending order and the last date is always a given
number of rows from the end i wondered if there is a way to find out
how many rows had been used. There are also blank rows in between so
ive not been able to go down this road.
 
C

ceemo

unfortunatly i cant do a max(A:A) function because the general format i
text not numeric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max; Min & Dates 2
Max Length in a row 1
Return MAX value from column B and Name from column A 2
Date-related problems - max and datevalue 3
Sorting 4
Date separator 1
VBA Show in red if Date > another date 2
Date Formula for number of days between a date and today 7

Top