Forum Discussion

Raymond Grubb's avatar
Raymond Grubb
Copper Contributor
Mar 11, 2018

Excel Date

Hi, if I have a range of dates in a column, how can I automatically show the first and last dates?
excel
  • Mark Adams's avatar
    Mark Adams
    Copper Contributor
    Mar 12, 2018
    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.

Resources