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

<?php

// Settlement, Maturity, Frequency, Basis, Result

return [
    [
        71,
        '25-Jan-2007',
        '15-Nov-2008',
        2,
        1,
    ],
    [
        66,
        '2011-01-01',
        '2012-10-25',
        4,
    ],
    [
        66,
        '2011-01-01',
        '2012-10-25',
        4,
        null,
    ],
    [
        71,
        '2011-01-25',
        '2011-11-15',
        2,
        1,
    ],
    [
        '#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,
    ],
    [
        311,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        0,
    ],
    [
        317,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        1,
    ],
    [
        317,
        '31-Jan-2020',
        '20-Mar-2021',
        1,
        1,
    ],
    [
        317,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        2,
    ],
    [
        317,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        3,
    ],
    [
        310,
        '31-Jan-2021',
        '20-Mar-2021',
        1,
        4,
    ],
    [
        131,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        0,
    ],
    [
        133,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        1,
    ],
    [
        133,
        '31-Jan-2020',
        '20-Mar-2021',
        2,
        1,
    ],
    [
        133,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        2,
    ],
    [
        133,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        3,
    ],
    [
        130,
        '31-Jan-2021',
        '20-Mar-2021',
        2,
        4,
    ],
    [
        41,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        0,
    ],
    [
        42,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        1,
    ],
    [
        42,
        '31-Jan-2020',
        '20-Mar-2021',
        4,
        1,
    ],
    [
        42,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        2,
    ],
    [
        42,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        3,
    ],
    [
        40,
        '31-Jan-2021',
        '20-Mar-2021',
        4,
        4,
    ],
    [
        5,
        '05-Apr-2019',
        '30-Sep-2021',
        2,
        0,
    ],
    [
        5,
        '05-Oct-2019',
        '31-Mar-2022',
        2,
        0,
    ],
];