Counting Active projects within 2 dates
I have 2 date columns: Actual Start and Actual Finish in my intake sheet and want to summarize active projects by month over time.
I setup trend sheet with months and years and want the formula to count actives for the month if:
Actual Start is NOT blank
AND Actual Start (Less than or equal to the Month/Year on the row in the Trend sheet)
AND Actual Finish is blank OR > Month Year on the row in the trend sheet
Help Article Resources
Check out the Formula Handbook template!