P
PattiJ621
I need to calculate ages as of 8/1/06. How can I do this if I enter the
Birthdates for each participant?
Birthdates for each participant?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
SteveG
T
Tom Ogilvy
P
PattiJ621
I tried that ... can somebody explain it simpler?
P
Paul B
PattiJ621, See if this will do what you want, put this in a cell and put
your birthday in A1
=DATEDIF(A1,DATE(2006,8,1),"y") & " years, " &
DATEDIF(A1,DATE(2006,8,1),"ym") & " months, " &
DATEDIF(A1,DATE(2006,8,1),"md") & " days"
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
your birthday in A1
=DATEDIF(A1,DATE(2006,8,1),"y") & " years, " &
DATEDIF(A1,DATE(2006,8,1),"ym") & " months, " &
DATEDIF(A1,DATE(2006,8,1),"md") & " days"
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003