Work due in the next 7 days
Where am I going wrong with this formula? I want to see tasks that have a {Need by Date} of TODAY through the next 7 Days and also filter out any Assignee's {Task Range 1} that say "Schedule Milestone"? Thanks for everyones support on this one :) Both of the datasets would both be pulling from another sheet.
=COUNTIFS({Tasks Range 1}, <>"Schedule Milestone", {Need by}, >=TODAY(7))
Answers
-
@Greg Zinn Assuming that when you say "I want to see tasks that have the date of today through the next 7 days" you mean between today and next 7 days, below is what should work for you:
=COUNTIFS({Task Range 1},<>"Schedule Milestone",{Need by},AND(@cell >= TODAY(),@cell <= TODAY(7)))
-
Thanks for your help but it does not seem to work.. Getting INVALID REF.
-
Nevermind got it to work. Thank you for all your help on this!
-
What would the inverse be if I was looking for things due in the past 7 days?
-
Use this,
=COUNTIFS({Task Range 1},<>"Schedule Milestone",{Need by},AND(@cell >= TODAY(-7),@cell <= TODAY()))
Please do not forget to flag this as an answer so that others in the community can refer to if they have similar query.
Help Article Resources
Categories
Check out the Formula Handbook template!