=IF(B2=TODAY(),"Past",IF(B2<TODAY(),"Today",TEXT(B2,"ddd")))- 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:
