I work in a gym and we have memberships that have expired in 2015/2016 on various dates and current members in 2016 with an active membership.
I have all the data of over 200 clients in random order in the table
I am trying to produce a formula to tell me which members expired in the corresponding months and when members who still have an active membership will need renewal
The aim of this is to identify when and where marketing strategies can be applied and to try and investigate any trends that may arise.
I have tried several formulas but i cant extract the months from the data whilst differentiating the years.
(dates are in dd/mm/yyyy layout)
Bookmarks