OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-comment] DAYS360 third parameter should be Logical


On Thursday, 2016-06-30 11:10:39 -0600, Andreas J. Guelzow wrote:

> The difference between methods 0 and 2 is visible for example for
> =DAYS360(DATE(2015,2,27),DATE(2016,2,29),method)
> which in Gnumeric evaluates to 362 for method=0 (or 1) and 363 for method=2

In Excel and LibreOffice =DAYS360(DATE(2015,2,27),DATE(2016,2,29),2)
evaluates to 362.


LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/
Care about Free Software, support the FSFE https://fsfe.org/support/?erack

Attachment: signature.asc
Description: PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]