B BB Feb 4, 2010 #1 I need to create a formula to calculate age as of 04-30-10. Can anyone help me? I am using Excel 2007.
I need to create a formula to calculate age as of 04-30-10. Can anyone help me? I am using Excel 2007.
N Niek Otten Feb 4, 2010 #2 =DATEDIF(A1,B1,"y") with variable date in A1 and today's date in B1 Look here: http://www.cpearson.com/excel/datedif.aspx
=DATEDIF(A1,B1,"y") with variable date in A1 and today's date in B1 Look here: http://www.cpearson.com/excel/datedif.aspx
