Formula to determine is something is due this week
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?
Help Article Resources
Check out the Formula Handbook template!