Formula help!!

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?

Find more posts tagged with

Formulas

IT & Operations

Project Management

Comments

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