I have 2 tables of dates in the format DD-MM-YYYY
I want to compare the 2 set of dates
to find out which dates are preceding the others
Real dates are just numbers, hence you should be able to just Data Sort to
taste. If it doesn't respond to sort, then the dates are not real dates
recognized by Excel. In which case, you can try using Data Text to Columns
to convert it all at one go (ie the col(s) of "dates") to real dates. In step
3 of the wizard, check "Dates", then select the appropriate date format (eg:
DMY) for the data.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---