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
Bookmarks