You should be able to use the MIN and MAX functions for this.

=MIN(O7:O31)
=MAX(O7:O31)

Make sure your cells are formatted as dates.

HTH,
Elkar


"Bob Smith" wrote:

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