Forum Discussion
Excel Date
Hi, if I have a range of dates in a column, how can I automatically show the first and last dates?
You can use the MIN and MAX function on dates just as you would a range
of numbers. If your dates are in A1:A10, then MIN(A1:A10) will show the
first chronological date and MAX(A1:A10) will show the last
chronological date.