The DATEDIF function is in all versions of Excel, but documented
only in Excel 2000. See www.cpearson.com/excel/datedif.htm for
details and documentation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"BekkiM" wrote in message
...
Philip: Where is the "DATEDIF" function? I don't see it my
list. Is there
an Add-In I'm missing?

"Philip J Smith" wrote:

Try

=datedif(BirthDate,BenchmarkDate,"Y")

Regards

Phil Smith

"yancey04" wrote:

I need to write a formula that calculates a childs age as
of 04/30/2006 for
baseball or as of 01/01/06 for softball.