View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default compare 2 tables of dates to find the preceding dates

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
---