+ Reply to Thread
Results 1 to 2 of 2

Extracting dates from a client database

  1. #1
    Registered User
    Join Date
    01-29-2016
    Location
    warrington, cheshire, england
    MS-Off Ver
    2010
    Posts
    1

    Extracting dates from a client database

    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)

  2. #2
    Registered User
    Join Date
    01-06-2016
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    20

    Re: Extracting dates from a client database

    Hello @aaronbaxter,
    You will probably need to upload a sample workbook.

    -Jon

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 10-10-2014, 06:11 AM
  2. Appointment Calendar that automatically syncs with Excel Client Database
    By Earthsong in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2014, 08:13 PM
  3. Help with client database?
    By ClientDatabase in forum Excel General
    Replies: 1
    Last Post: 02-06-2014, 06:50 PM
  4. List Client Appointments outside of Normal Induction dates
    By john dalton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-01-2013, 09:27 AM
  5. [SOLVED] how do I set up a database for client information
    By Insurance Tracie in forum Excel General
    Replies: 1
    Last Post: 05-13-2005, 01:06 PM
  6. Extracting data from a client worksheet to create an invoice
    By Jacques E. Bouchard in forum Excel General
    Replies: 1
    Last Post: 05-08-2005, 03:06 AM
  7. What's the easiest way to set up a client pipline w COE dates and.
    By Vanessa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2005, 08:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1