Forum Discussion

Claudiu220's avatar
Claudiu220
Copper Contributor
Apr 01, 2023

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!

excel

2 Replies

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 01, 2023

    Claudiu220 

    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, "")

Resources