Count of Days Worked

Crystal Perry

What I need is a monthly count of what days were worked during the month (Based off form submissions) regardless of quantity. For example, if our Customer Repair/Renewal Workshop gets 10 submissions on December 1st and 15 submissions on December 6th, all I need to have the formula count is the 2 days worked during that timeframe.

Paul Newcome

Try this...

=COUNT(DISTINCT(COLLECT([Date Only]:[Date Only], [Date Only]:[Date Only], AND(IFERROR(YEAR(@cell), 0) = 2021, IFERROR(MONTH(@cell), 0) = 12)))))

Paul Newcome

Try this...

=COUNT(DISTINCT(COLLECT([Date Only]:[Date Only], [Date Only]:[Date Only], AND(IFERROR(YEAR(@cell), 0) = 2021, IFERROR(MONTH(@cell), 0) = 12)))))