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?
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?