Hi
I need some help with a formula, I want the formula to look at cell B171 and if the date in the cell is more than 2 days old enter HIDE in the F171 cell - This works in the formula below but also shows hide if there is no date in B171.
How can I show nothing if there is no date in B171
=IF(TODAY()-$B171>2, "Hide", "")
Thanks
I need some help with a formula, I want the formula to look at cell B171 and if the date in the cell is more than 2 days old enter HIDE in the F171 cell - This works in the formula below but also shows hide if there is no date in B171.
How can I show nothing if there is no date in B171
=IF(TODAY()-$B171>2, "Hide", "")
Thanks