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...
A 365 solution with no fill handle:
=LET(
CountDates, LAMBDA(row, SUM(N(TEXT(Dates, "mmm") = row))),
BYROW(Months, CountDates)
)