Hi

You can calculate the birthday in current year from birth date as
=DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdate))
, or to cope with cases when bith date was 29. February
=MIN(DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdate)),DATE(YEAR(TODAY()),
MONTH(Birthdate)+1,0))

Now, when you have the table of park members, you can use conditional
formatting to display rows in different colors, when some estimated number
of days is left to person bithday. Something like:
Display entries in a row red, when
=(DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdate))-TODAY()=0)
Display entries in a row violet, when
=(DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdate))-TODAY()>0 AND
DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdate))-TODAY()<4)
Display entries green, when
=(DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdate))-TODAY()>3 AND
DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdate))-TODAY()<31)


Arvi Laanemets


"Platski" <Platski.25lelm_1143906901.4798@excelforum-nospam.com> wrote in
message news:Platski.25lelm_1143906901.4798@excelforum-nospam.com...
>
> I keep details of my members at my skate park in a worksheet. Dates of
> birth are entered and then I am using the following formula to
> calculate ages:
>
> =DATEDIF(J252,NOW(),"y") & " years, " & DATEDIF(J252,NOW(),"ym") & "
> months, " & DATEDIF(J252,NOW(),"md") & " days"
>
> so that my answer reads ? years ? months, ? days.
>
> What I would like to do is have 1.) a formula which calculates the
> average age and also 2.) one which can easily identify who's birthday
> it is on todays date or better still a formulae which identifies
> members who's birthday is due in 30 days time (so we can offer birthday
> party options 30 days in advance)
>
> Any help would be appreciated as I am now getting out of my depth.
>
> As a reward, if you are ever in Dubai, United Arab Emirates, come skate
> free!
>
> Thanks
>
> Chris
>
>
> --
> Platski
> ------------------------------------------------------------------------
> Platski's Profile:
http://www.excelforum.com/member.php...o&userid=33075
> View this thread: http://www.excelforum.com/showthread...hreadid=528866
>