Re: Birthday calculations

=DATE(YEAR(TODAY())+IF(TEXT(TODAY(),"mmdd")>TEXT(C3,"mmdd"),1,0),MONTH(C3),DAY(C3))-TODAY()

Works OK for leap years, depending on what your definition is of the
birthdays in non-leap years for those born on Feb. 29

--
Kind regards,

Niek Otten

"JC" <jhoppyc@xxxxxxxxxxxxxxxxxxx> wrote in message
news:k62002lsturu35g810cku6okken2gib23o@xxxxxxxxxx
Hi,

I am setting up a spread*** to calculate people's age and the number of
days
to their next birthday. Calculating their age I can do but calculating
the
number of days until their next birthday is proving a little difficult.

I am currently using the formula =365-DATEDIF($C3,TODAY(),"yd") where the
full
dd/mm/yyyy birth date is in c3.

It occurred to me that the formula will be correct for non leap years but
will
probably be one day out on leap years.

I would welcome any suggestions on how to correct the above formula to
compensate for leap years?
--

Cheers . . . JC


.