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