How to display the first and last dates in series of dates?

  • Thread starter Thread starter superock
  • Start date Start date
S

superock

Hi all,

I would like to display the first date (Earliest in seperate cell) an
the last date (Latest in seperate cell) of a column of dates, thes
dates in the column would be in a random order and should not just b
sorted (wich would obviously solve the problem)

I thought DATEDIFF may help but am not sure, thanks for any help.

Superoc
 
Hi Superock!

Since dates are serial numbers from 31-Dec-1899, you can use MIN to
get the earliest date and MAX to get the latest.
 
Back
Top