Formula to Return age
in [Functions]
|
Prev: copy data from one sheet to another using a combo box
Next: How do I count # of cells with same value other column?
From: JLatham on 7 Apr 2010 20:21 see http://www.cpearson.com/excel/datetimews.htm scroll down just a few lines and he has a formula for determining age in years, months and days. "Mark" wrote: > Hi, Trying to get an age cell to self populate based on a cell containing > persons date of birth. As always thanks for your help. > -- > Mark N
From: Gord Dibben on 7 Apr 2010 21:04
Might be easier to go straight to http://www.cpearson.com/excel/datedif.aspx Gord On Wed, 7 Apr 2010 17:21:01 -0700, JLatham <JLatham(a)discussions.microsoft.com> wrote: >see >http://www.cpearson.com/excel/datetimews.htm >scroll down just a few lines and he has a formula for determining age in >years, months and days. > > >"Mark" wrote: > >> Hi, Trying to get an age cell to self populate based on a cell containing >> persons date of birth. As always thanks for your help. >> -- >> Mark N |