Forum Discussion
formula for counting total members per month at the end of the month based on enrollment dates
| Person 1 | 8/1/2022 | JAN | |
| Person 2 | 5/1/2016 | FEB | |
| Person 3 | 3/14/2019 | MAR | |
| Person 4 | 1/1/2020 | APR | |
| Person 5 | 4/1/2023 | MAY | |
| Person 6 | 12/1/2020 | JUN | |
| Person 7 | 5/22/2009 | JUL | |
| Person 8 | 4/20/2023 | AUG | |
| Person 9 | 1/4/2011 | SEP | |
| Person 10 | 6/7/2021 | ||
| Person 11 | 3/5/2012 | ||
| Person 12 | 8/1/2017 | ||
| Person 13 | 1/4/2022 | ||
| Person 14 | 11/2/2016 | ||
| Person 15 | 2/4/2000 |
Column headings:
Name
Date of enrollment
Month for this calendar year
Total number of enrollees at the end of each month
Thanks!
1 Reply
A 365 solution with no fill handle:
=LET( CountDates, LAMBDA(row, SUM(N(TEXT(Dates, "mmm") = row))), BYROW(Months, CountDates) )
