Count If Date is Between, Rolling Dates
I have a process that will all automatic rolling of dates. So -2 is two months ago, -1 one, 0 current month etc. So I need a formula that I can use this automatic rolling to check projects on another sheet to count resources during that month that are used by role.
Count if Role matches, Count if "rolling month" is between the start and finish dates.
These pictures show the sheets I am working with.
Help Article Resources
Check out the Formula Handbook template!