One of the formalas that is not documented in Excel 2003, 2007 and 2010 is the DATEDIF function.
The syntax of DATEDIF is =DATEDIF(Start Date, End Date, Type).
Placing the Birth Date on C8: (1/1/1960), the number of years lived will be =DATEDIF(C8,TODAY(),"y")
Download the file here: Calculating Age in Excel using DATEDIF
Wednesday, November 16, 2011
Calculating Age in Excel using DATEDIF
Labels:
Excel Functions,
Formulas
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment