Birthday is x days away?

**Ltat42a** · 01-07-2009, 05:31 PM

I have a column with people(A) and their date of birth(C). I'm looking to find out the number of days when their next birthday is. I searched through here and couldn't find anything.

Is there a formula I can use that would calculate this, year after year after year??

Thanx..

**VBA Noob** · 01-07-2009, 05:37 PM

Take a look at dateif.

Example at the bottom called Calculating Age

http://www.cpearson.com/excel/datedif.aspx

VBA Noob

**NBVC** · 01-07-2009, 05:38 PM

Try:

=DATEDIF(TODAY(),C1,"d")

where C1 contains birthdate

**daddylonglegs** · 01-07-2009, 05:41 PM

This formula will give you a result like

"Next birthday is 123 days away". On birthday it says "Happy Birthday!"

=IF(DATEDIF(C1,TODAY(),"yd")=0,"Happy Birthday!","Next birthday is "&DATE(YEAR(C1)+DATEDIF(C1,TODAY(),"y")+1,MONTH(C1),DAY(C1))-TODAY()&" days away")

where C1 contains date of birth

**Ltat42a** · 01-07-2009, 05:54 PM

Originally Posted by daddylonglegs

This formula will give you a result like

"Next birthday is 123 days away". On birthday it says "Happy Birthday!"

=IF(DATEDIF(C1,TODAY(),"yd")=0,"Happy Birthday!","Next birthday is "&DATE(YEAR(C1)+DATEDIF(C1,TODAY(),"y")+1,MONTH(C1),DAY(C1))-TODAY()&" days away")

where C1 contains date of birth

Cool....works good, Thanx.