Count number of dates that meet several criteria

B Young

What would be the formula that counts the number of dates that fall between a start and finish date if another column is not blank? Current formula I have is: =COUNTIFS({Dates}, >=[Start Date]@row, {Dates}, <=[End Date]@row) This is returning the total number of dates correctly. But would like it to return the number of dates between that date range if another column is not blank.

Andrée Starå

Hi @B Young

I hope you're well and safe!

Try something like this.

=COUNTIFS({Dates}, >=[Start Date]@row, {Dates}, <=[End Date]@row, {Other Range}, <>"")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

You would add another range/criteria set using the same syntax that you already have in your existing formula.

Kaveri Vipat

Hi B Young 

Please can you add some screenshots (Hide confidential data) for better understanding, I am not able to understand what other column should not be blank here? 

Have a Good Day! 

Andrée Starå

Hi @B Young

I hope you're well and safe!

Try something like this.

=COUNTIFS({Dates}, >=[Start Date]@row, {Dates}, <=[End Date]@row, {Other Range}, <>"")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

B Young

Thank you @Andrée Starå this works! Appreciate your help.

Andrée Starå

@B Young

Excellent!

Happy to help!