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(Birth date)),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(Birthdat e))-TODAY()=0)
Display entries in a row violet, when
=(DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdat e))-TODAY()0 AND
DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdate) )-TODAY()<4)
Display entries green, when
=(DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdat e))-TODAY()3 AND
DATE(YEAR(TODAY()),MONTH(Birthdate),DAY(Birthdate) )-TODAY()<31)


Arvi Laanemets


"Platski" wrote in
message ...

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