I am trying to calculate the mean lifetime of customers every month. I have a table where the discharge date and date low of each customer appears. I want to calculate the number of customers who are active each month and the number of days that have been active until this month, later to calculate the average.
Excel attached an example of what I'm trying to do.
Many thanks for your time.