View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Smith Bob Smith is offline
external usenet poster
 
Posts: 28
Default Finding the oldest & newest dates

Hi folks,

I've got a spreadsheet, where there a number of different dates & times in
column O (cells O7 through O31). All these dates are imported from different
worksheets in the same workbook, via copy/paste special.

I'd like to list the oldest date/time in cell E2 and the newest date/time in
E3. I've tried a number of different formulas with no correct results.

Can anyone provide some suggestions?

TIA, Bob