<today's date
Make that your "certain date"
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Niek Otten" wrote in message
...
=DATEDIF(A1,B1,"y")
with variable date in A1 and today's date in B1
Look he
http://www.cpearson.com/excel/datedif.aspx
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"BB" wrote in message
...
I need to create a formula to calculate age as of 04-30-10. Can anyone
help
me? I am using Excel 2007.