YearFrac Year Fraction Calculation

[BennyD]

I have the Microsoft Excel 11.0 Object Library installed as Reference
in my Access database. However, I cannot get the YearFrac function to
work.

Does anyone know how to make use of the YearFrac function in Access?

I've tried using the DateDiff, but it's programatically arduous to use
it in order to replicate the YearFrac results.

Any help would be appreciated. Thanks

[Douglas J. Steele]

According to the Excel help file "If this function is not available, and
returns the #NAME? error, install and load the Analysis ToolPak add-in." For
information about using functions from add-ins, see
http://support.microsoft.com/?id=198571

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"BennyD" <be****@ix.netcom.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

I have the Microsoft Excel 11.0 Object Library installed as Reference
in my Access database. However, I cannot get the YearFrac function to
work.

Does anyone know how to make use of the YearFrac function in Access?

I've tried using the DateDiff, but it's programatically arduous to use
it in order to replicate the YearFrac results.

Any help would be appreciated. Thanks