https://bz.apache.org/bugzilla/show_bug.cgi?id=60029
Mark Murphy <jmarkmur...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from Mark Murphy <jmarkmur...@apache.org> ---
(In reply to Julien Houeix from comment #0)
> Hello,
>
> There is a problem with the Days360 class in POI
> (org.apache.poi.ss.formula.functions.Days360.class).
>
> The result of the evaluation is not the same as the Excel method when the
> start date is the last day of february and the end date is the last day of
> the month:
> Start date: 02/28/2018
> End date: 03/31/2018
> Result in Excel: 30
> Result in Apache POI: 31
I just tried this in Excel 2016, and it gave me 31. Maybe your build of Excel
has a bug? 31 is indeed the correct answer.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
