xny/vendor/phpoffice/phpspreadsheet/tests/data/Calculation/Financial/COUPDAYSNC.php

<?php

// Settlement, Maturity, Frequency, Basis, Result

return [
    [
        110,
        '25-Jan-2007',
        '15-Nov-2008',
        2,
        1,
    ],
    [
        24,
        '2011-01-01',
        '2012-10-25',
        4,
    ],
    [
        24,
        '2011-01-01',
        '2012-10-25',
        4,
        null,
    ],
    [
        '#VALUE!',
        'Invalid Date',
        '15-Nov-2008',
        2,
        1,
    ],
    [
        '#VALUE!',
        '25-Jan-2007',
        'Invalid Date',
        2,
        1,
    ],
    'Invalid Frequency' => [
        '#NUM!',
        '25-Jan-2007',
        '15-Nov-2008',
        3,
        1,
    ],
    'Non-Numeric Frequency' => [
        '#VALUE!',
        '25-Jan-2007',
        '15-Nov-2008',
        'NaN',
        1,
    ],
    'Invalid Basis' => [
        '#NUM!',
        '25-Jan-2007',
        '15-Nov-2008',
        4,
        -1,
    ],
    'Non-Numeric Basis' => [
        '#VALUE!',
        '25-Jan-2007',
        '15-Nov-2008',
        4,
        'NaN',
    ],
    'Same Date' => [
        '#NUM!',
        '24-Dec-2000',
        '24-Dec-2000',
        4,
        0,
    ],
    [
        49,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        0,
    ],
    [
        49,
        '01-Feb-2021',
        '20-Mar-2021',
        1,
        0,
    ],
    [
        48,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        1,
    ],
    [
        49,
        '31-Jan-2020',
        '20-Mar-2021',
        1,
        1,
    ],
    [
        48,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        2,
    ],
    [
        48,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        3,
    ],
    [
        50,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        4,
    ],
    [
        49,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        0,
    ],
    [
        49,
        '01-Feb-2021',
        '20-Mar-2021',
        2,
        0,
    ],
    [
        48,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        1,
    ],
    [
        49,
        '31-Jan-2020',
        '20-Mar-2021',
        2,
        1,
    ],
    [
        48,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        2,
    ],
    [
        48,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        3,
    ],
    [
        50,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        4,
    ],
    [
        49,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        0,
    ],
    [
        49,
        '01-Feb-2021',
        '20-Mar-2021',
        4,
        0,
    ],
    [
        48,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        1,
    ],
    [
        49,
        '31-Jan-2020',
        '20-Mar-2021',
        4,
        1,
    ],
    [
        48,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        2,
    ],
    [
        48,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        3,
    ],
    [
        50,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        4,
    ],
    [
        175,
        '05-Apr-2019',
        '30-Sep-2021',
        2,
        0,
    ],
    // Excel and LibreOffice return 175 for the following calculation.
    // Gnumeric returns 176.
    // My hand calculation, hardly guaranteed, agrees with Gnumeric.
    [
        176,
        '05-Oct-2019',
        '31-Mar-2022',
        2,
        0,
    ],
];