Report help

1

How can I figure out average length of club membership? Thanks!

2

Hi there, I’m hoping someone can contribute a faster way of doing this, but what I’ve been doing is this:

  1. Run an active club member report and download into Excel file.
  2. Add two new columns next to the “Signup Date” column
  3. Populate the first column all with today’s date
  4. Copy this formula into all cells of the second new column:
    =DATEDIF(A1,A2,“m”)
    but change A1 to your “start date” cell and A2 to your “Today’s Date” cell. This will calculate the total number of months in the club.
  5. Add the entire column with the months in club.
  6. Divide this total by the number of club members you have.

I changed the date format to show the entire year, X/X/XXXX but I can’t remember if that needed to be done or not…

Hope that helps!

1 Like
3

I am trying to do the same thing. You will need to export to excel. I did the same thing as Laura with with a separate formula. https://support.microsoft.com/en-us/help/214134/how-to-calculate-the-number-of-months-between-two-dates-in-excel

4

Depending on how old your Wine Club itself is, I might recommend doing a MEDIAN membership length as well to give you a better picture on how long the typical person stays in your Wine Club.

1 Like
5

Thanks everyone