Results 1 to 15 of 15

Upcoming Birthdays

Threaded View

  1. #13
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Upcoming Birthdays

    One way:

    A
    B
    C
    D
    E
    F
    1
    Name
    DOB
    Next B'day
    Days
    2
    Hana
    21 Sep 1987
    09/21/2014
    17
    C2: =EDATE(B2, 12*(DATEDIF(B2+1, TODAY(), "y") + 1))
    3
    Barb
    27 Sep 2009
    09/27/2014
    23
    D2: =C2-TODAY()
    4
    Ulis
    20 Oct 1997
    10/20/2014
    46
    5
    Ivan
    21 Oct 1995
    10/21/2014
    47
    6
    Tina
    20 Nov 2004
    11/20/2014
    77
    7
    Quin
    25 Nov 1988
    11/25/2014
    82
    8
    Eric
    04 Dec 1998
    12/04/2014
    91
    9
    Cain
    13 Dec 2005
    12/13/2014
    100
    10
    Dana
    18 Dec 2008
    12/18/2014
    105
    11
    Kent
    19 Dec 1997
    12/19/2014
    106
    12
    Gary
    24 Jan 1990
    01/24/2015
    142
    13
    Vera
    10 Feb 2001
    02/10/2015
    159
    14
    Otto
    26 Feb 2009
    02/26/2015
    175
    15
    Wade
    04 Apr 1986
    04/04/2015
    212
    16
    Xana
    15 Apr 2008
    04/15/2015
    223
    17
    Seth
    16 Apr 2000
    04/16/2015
    224
    18
    Jane
    18 Apr 1994
    04/18/2015
    226
    19
    Rene
    20 May 2001
    05/20/2015
    258
    20
    Mark
    02 Jun 1990
    06/02/2015
    271
    21
    Alan
    09 Jun 1999
    06/09/2015
    278
    22
    Fran
    19 Jun 1990
    06/19/2015
    288
    23
    Peri
    23 Jul 1982
    07/23/2015
    322
    24
    Nina
    24 Jul 1990
    07/24/2015
    323
    25
    Leah
    26 Aug 2005
    08/26/2015
    356


    Sort by the Days column.
    Last edited by shg; 09-04-2014 at 06:49 PM.
    Entia non sunt multiplicanda sine necessitate

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Highlighting Birthdays
    By alidde in forum Excel General
    Replies: 3
    Last Post: 07-17-2012, 10:59 AM
  2. Coincident Birthdays
    By milleran in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-20-2010, 03:38 PM
  3. Birthdays
    By Platski in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2006, 02:20 PM
  4. [SOLVED] Highlight birthdays
    By jocker in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-03-2006, 12:50 PM
  5. [SOLVED] Excel & birthdays
    By Norma in forum Excel General
    Replies: 3
    Last Post: 08-10-2005, 11:05 PM

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