Identify "youngest" date from "Created Date" Column

Hey Smart Heads,

I have another question about our beloved topic of formulas.


I have a autogerated column with row created date. In the file, rows are added in 2 ways:

  • In bulk, by senior auditor
  • Ad-hock by auditor

I would like to diferentiate these two types of inflow. I came up with an idea of finding "earliest" date from the column and convert "day" into benchmark, see:

=IF(MID(Created@row, 5, 1) > 1, "NEW", "BASIC")

This requires maintenance from sheet admin to validate results. There might be a scenario that audit started in June and was continued in July, hence more sophisticated solution would be appreciated.

Thanks in advance,



Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    If you have some sample data this is should be easy enough for you to test:

    =IF(DATEONLY(MIN(Created:Created)) = DATEONLY(Created@row), "Basic", "New")

    This will have anything put in on the earliest date show as "Basic", anything after that date would be "New".