+ Reply to Thread
Results 1 to 4 of 4

Extract birthday date and month

  1. #1
    Registered User
    Join Date
    01-20-2011
    Location
    Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    34

    Extract birthday date and month

    I have a very long list of people with there birthdays (date, month, year). I would like to:
    1. Count how many people in the list were born on specific day (birthday- only day and month-no year) in order to send irthday greeting cards (need only number of people)
    2. Is possible along with bithday dates to extract the name of the people- actually creating a new list of people born on this day.
    I would like to sove these points with formulas

    I tried to solve the problem with pivot table but without success.
    Thanks in advance for the help

  2. #2
    Registered User
    Join Date
    12-18-2010
    Location
    UK
    MS-Off Ver
    2003, 2007, 2010
    Posts
    79

    Re: Extract birthday date and month

    Please put up your spreadsheet.
    David
    Access and Excel Developer | UK

  3. #3
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255

    Re: Extract birthday date and month

    Try the attached spreadsheet, it does most of what you want with formulas, however to get the list of names, requires you to use the Advanced Filter option in Excel. Instructions for the Advanced filter are within the spreadsheet.

    I have created a dummy list of Names in cells A9 to A16, with dates next to them in column B. If you enter a birth day and month in cells B2 and B3, cell B4 will diplay the number of birthdays on this date.

    The contents of G8:G??, will provide you with the list of names with the birthday entered into B2 and B3 using the Advanced Filter option (instructions in cell G1 to G5)

    Regards

    Gary
    Attached Files Attached Files

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Extract birthday date and month

    I adapted Gary's file to illustrate a possible Pivot approach.
    Attached Files Attached Files
    Last edited by DonkeyOte; 02-02-2011 at 12:12 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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