Did YearFrac US (NASD) 30/360 basis change?

E

Eric W. Bachtal

Anyone notice that the YearFrac US (NASD) 30/360 basis (that's the default one) changed sometime between Excel 97 and 2002?

Using this formula: =YEARFRAC(DATE(2002, 2, 28),DATE(2002, 12, 31),0)

In Excel 97: 0.833333333

In Excel 2002: 0.836111111

A difference of about a day.

Did I miss a Knowledge Base article?

Thanks in advance.
 

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 2
edate and yearfrac functions not tallying 1
Cannot verify XNPV with PV or HP-12C 4
Using a 360 day year 1
how to seen diference colour after before 30 days 3
COUPNCD & Bond pricing 0
Opening/converting other spreadsheet programs' files 2
30/360 Interest Caluculation 2

Top