Work due in the next 7 days

Greg Zinn

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))

Sameer Karkhanis

@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)))

Greg Zinn

Thanks for your help but it does not seem to work.. Getting INVALID REF.

Greg Zinn

Nevermind got it to work. Thank you for all your help on this!

Greg Zinn

What would the inverse be if I was looking for things due in the past 7 days?

Sameer Karkhanis

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.