How do I count planned completed action items by month?
I have an End Date column and a Status column. I would like to build a formula that counts if Status is "Complete" and End Date is a designated month and year.
I would like that formula to generate a 0 if none can be counted.
End Date column type is Date, so dates appear as DAY/MONTH/YEAR. Status column type is Dropdown list.
I am new to formulas (beyond the basics) so any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!