Forum Discussion

naheemhussainuk's avatar
naheemhussainuk
Copper Contributor
Oct 12, 2020

How to make a messange appear after date such as expired

Id like a text appear after a set Date to expired

2 Replies

  • naheemhussainuk 

    For example:

     

    IF(TODAY()>DATE(2020,10,31),"Expired","")

     

    The cell with the formula will be blank up to and including the last day of October. From the first day of November, it will show "Expired".

Resources