https://bugs.documentfoundation.org/show_bug.cgi?id=101071
--- Comment #6 from mahfiaz <[email protected]> ---
Created attachment 126618
--> https://bugs.documentfoundation.org/attachment.cgi?id=126618&action=edit
Screenshot of Excel 2007 and Calc side-by-side
Calc calculates the datediff using financial method, where every month is 30
days long regardless of it's actual length (referred to as 360-day calendar).
If the starting and ending date is not on the same day of the month, the
difference is added to the usual difference in months.
Appears like Excel doesn't care and just uses the length in days, so 1st
January to 1st February is different from 1st February to 1st March. Which is
wrong.
http://www.investopedia.com/exam-guide/series-7/debt-securities/compute-treasury-discount-yield.asp
says so: This day-count convention may actually make things more complicated,
but the 360-day year is now a tradition for calculating T-bill rates.
As a middle ground we could have functions named TBILLYIELD360.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
