Countif not returning the correct amount

[jamesaplant77]

I have been looking through all the posts and can't find anything that fixes my formula.

I have dates in range P5:P88 and some of the cells are blank.

I am also trying to bring back the dates, that are equal to today or greater by 30 days based on the values in range F5:F88

Here it is:

=COUNTIFS('Portfolio Data'!F5:F88,"Contractor",'Portfolio Data'!P5:P88,"="&Today()+30

Would really appreciate some help!!

 

[Fishboy]

equal to today or greater by 30 days

=COUNTIFS('Portfolio Data'!F5:F88,"Contractor",'Portfolio Data'!P5:P88,"="&Today()+30

You formula is checking for EXACTLY today + 30.

Try this: =COUNTIFS('Portfolio Data'!F5:F88,"Contractor",'Portfolio Data'!P5:P88,">="&Today()+30

 

[jamesaplant77]

Thanks Fishboy, but this formula is returning a value of 0, when it should be 28.

=COUNTIFS('Portfolio Data'!F5:F88,"Contractor",'Portfolio Data'!P5:P88,">="&Today()+30

I need the formula to count dates that are equal to today but aren't greater than 30 days from todays date.

 

[Fishboy]

Thanks Fishboy, but this formula is returning a value of 0, when it should be 28.

=COUNTIFS('Portfolio Data'!F5:F88,"Contractor",'Portfolio Data'!P5:P88,">="&Today()+30

I need the formula to count dates that are equal to today but aren't greater than 30 days from todays date.

My bad, that would be equal to or LESS THAN today +30

Swap the >= for a <= and see what that does.

 

[jamesaplant77]

Nice one Fishboy, that works, what if I wanted to count if they were greater than 30 but less than 60 from today?

That is my next challenge!!

 

[Fishboy]

Nice one Fishboy, that works, what if I wanted to count if they were greater than 30 but less than 60 from today?

That is my next challenge!!

Glad you got it working.

With regards to your newer query, I *believe* it should be something like this:

=COUNTIFS('Portfolio Data'!F5:F88,"Contractor",'Portfolio Data'!P5:P88,"<="&Today()+30,Portfolio Data'!P5:P88,">="&Today()+60)