max date
 

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.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=566515

max date
 

maybe the MAX function will be of help

--
Don Guillett
SalesAid Software

"ceemo" wrote in
message ...

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.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=566515

max date
 

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


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=566515

max date
 

really need some help on this guys/girl


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=566515

max date
 

send me the part of the workbook to my private email below

--
Don Guillett
SalesAid Software

"ceemo" wrote in
message ...

really need some help on this guys/girl


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=566515

max date
 

ive manged to get this sorted now but many thanks to all that have
assisted


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=566515