Hi all -
I would like to calculate if something is due this week based on a target date in another cell.
I have tried this formula: =IF((TODAY() - [Week Of]1) - 7 > 0, "no", "yes")
This formula pull in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for.
Is it possible to determine if something is due just in the current week?