Forum Discussion
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
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.
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.
Riny_van_Eekelen - Thanks so much!!!
