Skip to content

conditional past, present, future in spreadsheets/Excel

  • 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:

Published inenglish

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *