Forum Discussion

gutmn826's avatar
gutmn826
Copper Contributor
May 19, 2022
Solved

Excel Formula to review items on a report more than 2 days old

I have an Excel report that items only need to be reviewed that is 2 days old or more.  So I need a formula created to review.  Thanks

 

Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 19, 2022

    gutmn826 Let's you have a date in A1 and you want to flag the date if it's 2 days old or more. You could enter a formula in e.g. B1 like:

    =IF(TODAY( )-2 >= A1, "Review", "-")

    =IF(TODAY()-2>=A1,"Review","-")

     Alternatively, you may look into conditional formatting to add a visual effect to A1 as soon as the date becomes less then or equal to TODAY()-2.

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 19, 2022

    gutmn826 Let's you have a date in A1 and you want to flag the date if it's 2 days old or more. You could enter a formula in e.g. B1 like:

    =IF(TODAY( )-2 >= A1, "Review", "-")

    =IF(TODAY()-2>=A1,"Review","-")

     Alternatively, you may look into conditional formatting to add a visual effect to A1 as soon as the date becomes less then or equal to TODAY()-2.