CountIf Day is between Start and Due Date
I'm stumped in this formula...
I wish to perform a countif when a date is between two dates.
I have a Start Date and a Due Date Column and in another sheet I have a list of days.
and I want to count how many times the day June 07th is between Start Date and Due Date
In the case below June 07th should be counted as 1, June 09th should be counted as 2
I've tried with countifs, index, collect, etc, but I'm not getting there :(
Help Article Resources
Check out the Formula Handbook template!