I'm sure this is probably pretty simple, but I need a formula to basically say, if the date in B2 is more than 7 days old, give me a result of "old".
Thank you!
I'm sure this is probably pretty simple, but I need a formula to basically say, if the date in B2 is more than 7 days old, give me a result of "old".
Thank you!
=IF(B2 < TODAY()-7,"Old","Not old")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Perfect, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks