Originally Posted by Niek Otten

<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.