Forum Discussion
Date
Hi! I would like to make a cell that will warn me if more than 10, 14 and 30 days have passed since a date written by me in another cell. Thanks very much!
Let's say the date is in D2.
In the other cell, enter the formula
=IF(D2<TODAY()-30, "More than 30 days have passed!", IF(D2<TODAY()-14, "More then 14 days have passed!", IF(D2<TODAY()-10, "More than 10 days have passed!", "")))
or
=IFS(D2<TODAY()-30, "More than 30 days have passed!", D2<TODAY()-14, "More then 14 days have passed!", D2<TODAY()-10, "More than 10 days have passed!", TRUE, "")
Thank you!