Formula help!!

Stephen Annoni

Please view the screenshot I have provided below.

 

I am attempting to create a formula here that takes the whole assigned to row and the end date row. I want it to show the number of times it shows a certain name, in this case Dean, and if that task is one week past the current date. I would also like two weeks and three weeks or more. I  imagine the formula to look something like this below but I cannot quite get it right.

 

Formula: =COUNTIFS([Assigned To]:[Assigned To], "Dean Anhorn", [End Date]:[End Date], @cell >= (TODAY() - 7))

 

any insight?

 

J. Craig Williams

Stephen,

 

Your formula is looking for a matched between [End Date] from 7 days ago into the future, not 7 days ago and earlier.

Try <= instead of >=

 

Also, in this case, you do not need the @cell reference.

 

Hope this helps.

Craig

 

Craig