YearFrac

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

Excel has a function named YearFrac() which allows you to
specify where a year calculation uses 365 or 360 days. I
would like to use this in Access, however, when I include
it in a query it tells me it is undefined. It is listed
in the help screen. Can I get this function to work in
Access?
 
If you set a reference to the Excel Library, you should be able to use it.

Open any module
Choose Tools / References from the Menu
Scroll to find anything that starts with "Microsoft Excel" and check it

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.fmsinc.com/consulting/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yearfrac error? 3
Year Fraction 10
yearfrac format error? 4
YEARFRAC Function 2
What are the methods to Migrate AWS Workmail to Office 365? 3
yearfrac problem 2
Yearfrac problems 1
Work's on mine but not others 2

Back
Top