How to count late dates based with conditions

[Lookingforhelp2020]

I want to set up a metric for a sheet I have been working on but I am stuck on step 1. I would like to count the amount of tasks in a specific state that are over 7 days late from today's date.

I.e. - Count the task if column D says 'In Review' and the date in column T is 7+ days from today's date. Otherwise the task is not counted.

I have tried using this formula but it keeps showing me a count of 0:

=countifs(D:D,"In Review", T:T,"<=7"&Today())


Any help would be appreciated!

 

[Fluff]

Hi & welcome to MrExcel.
How about
=countifs(D:D,"In Review", T:T,"<="&Today()-7)

 

[Lookingforhelp2020]

Hi & welcome to MrExcel.
How about
=countifs(D:D,"In Review", T:T,"<="&Today()-7)

Hi! Thanks for the help! I tried moving the -7 around as mentioned but I am still getting a count of 0. Does it matter that the dates in column T are in the 05-Mar-2020 07:57 format?

 

[Fluff]

The format shouldn't matter as long as they are dates & not text.
Select the column & change the format to General, what do you see?

 

[Lookingforhelp2020]

I changed the format to general and I still see the same date/time format in the column.

I have even tried removing the -7 just to see if it would count any date that is late in general that is also in review and I still get a count of 0.

 

[Fluff]

I changed the format to general and I still see the same date/time format in the column.

In that case your dates are not real dates but text, you will need to convert them

 

[Lookingforhelp2020]

In that case your dates are not real dates but text, you will need to convert them

That did the trick. Thank you! I appreciate all your help!

 

[Fluff]

You're welcome & thanks for the feedback