Counting dates based on 2 values

[Dragonred]

I have a sheet that has 2 columns.
Column A is -Deadline
Column B is - Date completed.

I’m wanting to calculate the dates in column A that are within 5 days from Today, unless they have a completed date in the column next to it. I’ve tried Countifs to reference the dates in Column A using the Today ()+5 function (that part has worked),but When I reference column B to only count the blanks I keep getting 0.
=COUNTIFS(A:A,”>Today()+5, B:B,”<>”&”)

Any Ideas?

 

[Legacy 143009]

As far as I understand, you are doing just the opposite:

=COUNTIFS(A:A,">"&Today()-5, B:B,”=")

 

[Dragonred]

Hi, thank you for your reply, that formula is still counting all within 5days and not missing out the ones that have a complete date.

 

[Dragonred]

As far as I understand, you are doing just the opposite:

=COUNTIFS(A:A,">"&Today()-5, B:B,”=")

Hi, thank you for your reply, that formula is still counting all within 5days and not missing out the ones that have a complete date.

 

[Legacy 143009]

Do you want to count blanks in column B? Or the ones with a value?

 

[Legacy 143009]

Or try this:

=COUNTIFS(A:A,">"&Today()-5, B:B,”<>")

One of them should work.

 

[Dragonred]

Or try this:

=COUNTIFS(A:A,">"&Today()-5, B:B,”<>")

One of them should work.

Hi, It’s still giving the #Value! Error. I want to calculate how many dates in column A are 5 days away from deadline without including the ones that have been completed,(marked in column B with a date.

 

[fjns]

Hi, see this formula
=COUNTIFS(A:A,"<="&TODAY()+5,B:B,"="&"")

 

[Fluff]

Another option

=COUNTIFS(A:A,"<"&TODAY()+5, B:B,"")