Forum Discussion
naheemhussainuk
Oct 12, 2020Copper Contributor
How to make a messange appear after date such as expired
Id like a text appear after a set Date to expired
2 Replies
- naheemhussainukCopper ContributorThank you so much....you made my day.
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".