Count Projects by Year within a range
I've been scratching my head with a way to count all projects where the Start Sate or End Date have a year that matches a bucket.
Fore example, if a project's start date is 2020 or end date is 2020, then I need to count it in the 2020 sheet summary. A project where the start is 2019 and end is 2020 would also be added, and the same case for a project with the start of 2020 and end of 2021.
I've been trying to do this with a combination of countifs and ors, but coming up blank. Any suggestions? Thanks!
Help Article Resources
Check out the Formula Handbook template!