Find the lowest date value from WS names

Hi guys,

I've got a WB with multiple WS on it all of whom's names are dates in the format of "##-##-####" (dd-mm-yyyy)
examples of these would be: 01-01-2012, 04-12-2011, 09-09-2009 etc etc

how would i determine the lowest date value from these WS names?

Thanks
kind regards
jordan

Just in the case where there may be sheet names that are not in date format it would be worthwhile checking to see the sheet name is a date - this may not ever apply in your case

Please Login or Register  to view this content.