- Given a column B that contains dates in a sequential order.
- Shows a “Today” when it’s today.
- Shows a “Past” when is past.
- Shows an abbreviated name of the day of the week.
Here is an example using emojis instead of past/today: