Skip to content

conditional past, present, future in spreadsheets/Excel

Published by Silveira on 2023-06-27 
=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:

Published inenglish

Be First to Comment

Leave a Reply

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