Need birth date 3/27/91 to calculate cronological age in excel
 

Spread sheet application with names address and mm/dd/yyyy birthdates. I
need the birth dates to calculate to whole number (the age) 3/27/91 = 13.

Need birth date 3/27/91 to calculate cronological age in excel
 

See Chip Pearson's webpage
http://www.cpearson.com/excel/datedif.htm
it is builtin to Excel all versions even though most do not show it in Help.

=DATEDIF(B2,TODAY")

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vdubaya3" wrote in message ...
Spread sheet application with names address and mm/dd/yyyy birthdates. I
need the birth dates to calculate to whole number (the age) 3/27/91 = 13.

Need birth date 3/27/91 to calculate cronological age in excel
 

Just a small typo alert:

=DATEDIF(B2,TODAY(),"y")

(Chip's site explains it very nice.)



David McRitchie wrote:

See Chip Pearson's webpage
http://www.cpearson.com/excel/datedif.htm
it is builtin to Excel all versions even though most do not show it in Help.

=DATEDIF(B2,TODAY")

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vdubaya3" wrote in message ...
Spread sheet application with names address and mm/dd/yyyy birthdates. I
need the birth dates to calculate to whole number (the age) 3/27/91 = 13.

--

Dave Peterson