Count if date range

Catherine Shea

I am trying to create a formula that will tell me how many tasks that contain Map that are Flagged for CSO responsible that are due in 7 days, 14 days and 30 days from the Current Date or Revised Date (whichever is the great of the two)

ss5.7.2021.JPG

Paul Newcome

Try something like this...

=COUNTIFS(Tasks:Tasks, CONTAINS("Map", @cell), [CSO Responsible]:[CSO Responsible], @cell = 1, [Revised Target Date]:[Revised Target Date], AND(@cell >= TODAY(), @cell <= TODAY(7))) + =COUNTIFS(Tasks:Tasks, CONTAINS("Map", @cell), [CSO Responsible]:[CSO Responsible], @cell = 1, [Target Date]:[Target Date], AND(@cell >= TODAY(), @cell <= TODAY(7)), [Revised Target Date]:[Revised Target Date], @cell = "")

Catherine Shea

I pasted the formula in a a Test column and got #invalid

operation. Any idea of what I did wrong?

Paul Newcome

Invalid what exactly? There are a few errors that start with "INVALID", so it will help to know exactly which one it is for troubleshooting.