We are using CiviCrm 5.65.1.
We would like to extract historical membership counts for certain time periods in the past say CAlendat Year 2014, 2015 etc.
The typical membership status that we have are New, Current, Grace, Expired, Pending Cancelled, Deceased and Resigned.
New members join and have differing membership expiration dates. One complication is that we have a membership category of "Life" with a membership expiration date of 2100 and in some cases blank.
Question - what would be the easiest way to obtain this count on a historical calendar basis.