The logic itself is quite simple, but perhaps not intuitive.
Rather than check thatalldates are greater than the previous date, we check ifanyprevious date isgreaterthan the next date.
If we find even one, the dates are not in order.
If we find none (zero), they are.
This is anarray operationwhere both ranges contain five dates.
But it also requires that relevant cells in column A be empty.
IF then returns a check mark since all dates are in order.
any date moved by SORT).
If we find zero dates that are different, the check mark is returned.
Check mark character ()
Inserting a check mark character in Excel can be tricky.
The UNICHAR function was introduced in Excel 2013.
Conditional Formatting
you might also useconditional formattingto highlight invalid dates.
More than one condition can be tested by nesting IF functions.
The IF…
SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
Values can be sorted by one or more columns.
SORT returns a dynamic array of results.
