I have been playing with If statements to attempt to work out if a value in a cell is more than 7 days difference from Today().
I would like to do this as one formula rather than haveing a formula to work out the difference with a value in a different cell and then calling on the cell to see if it is greater/less than (x).
I've tried all the variations I can think of but can't quite get the syntax of greater than "X" of today.
If A1 is greater than "x" days of Today() then True, False.
Does anyone have a solution please?
Bookmarks