xny/vendor/phpoffice/phpspreadsheet/tests/data/Calculation/DateTime/YEARFRAC.php

<?php

return [
    [
        0.025,
        '2007-1-1',
        '2007-1-10',
        0,
    ],
    [
        0.025,
        '2007-1-1',
        '2007-1-10',
        null,
    ],
    [
        0.025,
        '2007-1-1',
        '2007-1-10',
        'omitted',
    ],
    [
        0.025,
        '2007-1-10',
        '2007-1-1',
        0,
    ],
    [
        0.024657534246580001,
        '2007-1-1',
        '2007-1-10',
        1,
    ],
    [
        0.025,
        '2007-1-1',
        '2007-1-10',
        2,
    ],
    [
        0.024657534246580001,
        '2007-1-1',
        '2007-1-10',
        3,
    ],
    [
        0.025,
        '2007-1-1',
        '2007-1-10',
        4,
    ],
    [
        1.0,
        '2007-1-1',
        '2007-12-31',
        0,
    ],
    [
        0.99726027397259998,
        '2007-1-1',
        '2007-12-31',
        1,
    ],
    [
        1.01111111111111,
        '2007-1-1',
        '2007-12-31',
        2,
    ],
    [
        0.99726027397259998,
        '2007-1-1',
        '2007-12-31',
        3,
    ],
    [
        0.99722222222222001,
        '2007-1-1',
        '2007-12-31',
        4,
    ],
    [
        1.5,
        '2007-1-1',
        '2008-7-1',
        0,
    ],
    [
        1.49658002735978,
        '2007-1-1',
        '2008-7-1',
        1,
    ],
    [
        1.5194444444444399,
        '2007-1-1',
        '2008-7-1',
        2,
    ],
    [
        1.4986301369863,
        '2007-1-1',
        '2008-7-1',
        3,
    ],
    [
        1.5,
        '2007-1-1',
        '2008-7-1',
        4,
    ],
    [
        0.083333333333329998,
        '2007-1-1',
        '2007-1-31',
        0,
    ],
    [
        0.082191780821919996,
        '2007-1-1',
        '2007-1-31',
        1,
    ],
    [
        0.083333333333329998,
        '2007-1-1',
        '2007-1-31',
        2,
    ],
    [
        0.082191780821919996,
        '2007-1-1',
        '2007-1-31',
        3,
    ],
    [
        0.080555555555560002,
        '2007-1-1',
        '2007-1-31',
        4,
    ],
    [
        0.083333333333329998,
        '2007-1-1',
        '2007-2-1',
        0,
    ],
    [
        0.084931506849319993,
        '2007-1-1',
        '2007-2-1',
        1,
    ],
    [
        0.08611111111111,
        '2007-1-1',
        '2007-2-1',
        2,
    ],
    [
        0.084931506849319993,
        '2007-1-1',
        '2007-2-1',
        3,
    ],
    [
        0.083333333333329998,
        '2007-1-1',
        '2007-2-1',
        4,
    ],
    [
        0.15833333333333,
        '2007-1-1',
        '2007-2-28',
        0,
    ],
    [
        0.15890410958904,
        '2007-1-1',
        '2007-2-28',
        1,
    ],
    [
        0.16111111111111001,
        '2007-1-1',
        '2007-2-28',
        2,
    ],
    [
        0.15890410958904,
        '2007-1-1',
        '2007-2-28',
        3,
    ],
    [
        0.15833333333333,
        '2007-1-1',
        '2007-2-28',
        4,
    ],
    [
        0.0027777777777800001,
        '2007-1-31',
        '2007-2-1',
        0,
    ],
    [
        0.0027397260273999999,
        '2007-1-31',
        '2007-2-1',
        1,
    ],
    [
        0.0027777777777800001,
        '2007-1-31',
        '2007-2-1',
        2,
    ],
    [
        0.0027397260273999999,
        '2007-1-31',
        '2007-2-1',
        3,
    ],
    [
        0.0027777777777800001,
        '2007-1-31',
        '2007-2-1',
        4,
    ],
    [
        0.08611111111111,
        '2007-1-31',
        '2007-3-1',
        0,
    ],
    [
        0.07945205479452,
        '2007-1-31',
        '2007-3-1',
        1,
    ],
    [
        0.080555555555560002,
        '2007-1-31',
        '2007-3-1',
        2,
    ],
    [
        0.07945205479452,
        '2007-1-31',
        '2007-3-1',
        3,
    ],
    [
        0.08611111111111,
        '2007-1-31',
        '2007-3-1',
        4,
    ],
    [
        0.16666666666666999,
        '2007-1-31',
        '2007-3-31',
        0,
    ],
    [
        0.16164383561644,
        '2007-1-31',
        '2007-3-31',
        1,
    ],
    [
        0.16388888888889,
        '2007-1-31',
        '2007-3-31',
        2,
    ],
    [
        0.16164383561644,
        '2007-1-31',
        '2007-3-31',
        3,
    ],
    [
        0.16666666666666999,
        '2007-1-31',
        '2007-3-31',
        4,
    ],
    [
        0.66666666666666996,
        '2008-1-1',
        '2008-9-1',
        0,
    ],
    [
        0.66666666666666996,
        '2008-1-1',
        '2008-9-1',
        1,
    ],
    [
        0.67777777777778003,
        '2008-1-1',
        '2008-9-1',
        2,
    ],
    [
        0.66849315068492998,
        '2008-1-1',
        '2008-9-1',
        3,
    ],
    [
        0.66666666666666996,
        '2008-1-1',
        '2008-9-1',
        4,
    ],
    [
        1.1666666666666701,
        '2007-2-1',
        '2008-4-1',
        0,
    ],
    [
        1.16279069767442,
        '2007-2-1',
        '2008-4-1',
        1,
    ],
    [
        1.18055555555556,
        '2007-2-1',
        '2008-4-1',
        2,
    ],
    [
        1.16438356164384,
        '2007-2-1',
        '2008-4-1',
        3,
    ],
    [
        1.1666666666666701,
        '2007-2-1',
        '2008-4-1',
        4,
    ],
    [
        47.524999999999999,
        '1960-12-19',
        '2008-6-28',
        0,
    ],
    [
        47.52162252765670,
        '1960-12-19',
        '2008-6-28',
        1,
    ],
    [
        48.216666666666697,
        '1960-12-19',
        '2008-6-28',
        2,
    ],
    [
        47.556164383561601,
        '1960-12-19',
        '2008-6-28',
        3,
    ],
    [
        47.524999999999999,
        '1960-12-19',
        '2008-6-28',
        4,
    ],
    [
        25.558333333333302,
        '1982-12-7',
        '2008-6-28',
        0,
    ],
    [
        25.5571892111134,
        '1982-12-7',
        '2008-6-28',
        1,
    ],
    [
        25.9305555555556,
        '1982-12-7',
        '2008-6-28',
        2,
    ],
    [
        25.575342465753401,
        '1982-12-7',
        '2008-6-28',
        3,
    ],
    [
        25.558333333333302,
        '1982-12-7',
        '2008-6-28',
        4,
    ],
    [
        0.163934426,
        '1960-01-01',
        '1960-03-01',
        1,
    ],
    [
        0.161643836,
        '1961-01-01',
        '1961-03-01',
        1,
    ],
    [
        0.161643836,
        '1963-03-01',
        '1963-01-01',
        1,
    ],
    [
        1.086183311,
        '1960-01-01',
        '1961-02-01',
        1,
    ],
    [
        1.084931507,
        '1961-01-01',
        '1962-02-01',
        1,
    ],
    [
        1.083447332,
        '1963-01-01',
        '1964-02-01',
        1,
    ],
    [
        1.162790698,
        '1963-01-01',
        '1964-03-01',
        1,
    ],
    [
        0.841530055,
        '2020-02-28',
        '2021-01-01',
        1,
    ],
    [
        0.764383562,
        '2020-03-28',
        '2021-01-01',
        1,
    ],
    [
        0.841530055,
        '2023-04-28',
        '2024-03-01',
        1,
    ],
    [
        0.838797814,
        '2023-04-28',
        '2024-02-29',
        1,
    ],
    [
        0.838356164,
        '2023-04-28',
        '2024-02-28',
        1,
    ],
    [
        0.753424658,
        '2023-04-28',
        '2024-01-28',
        1,
    ],
    [
        0.753424658,
        '2022-04-28',
        '2023-01-28',
        1,
    ],
    [
        1.0,
        '2020-01-01',
        '2021-01-01',
        1,
    ],
    [
        0.99726776,
        '2020-02-28',
        '2021-02-27',
        1,
    ],
    [
        0.764383562,
        '2020-03-28',
        '2021-01-01',
        1,
    ],
    [
        0.841530055,
        '2023-04-28',
        '2024-03-01',
        1,
    ],
    [
        0.838797814,
        '2023-04-28',
        '2024-02-29',
        1,
    ],
    [
        0.838356164,
        '2023-04-28',
        '2024-02-28',
        1,
    ],
    [
        0.753424658,
        '2023-04-28',
        '2024-01-28',
        1,
    ],
    [
        0.753424658,
        '2022-04-28',
        '2023-01-28',
        1,
    ],
    [
        1.082191781,
        '2022-04-28',
        '2023-05-28',
        1,
    ],
    [
        1.002739726,
        '2022-04-27',
        '2023-04-28',
        1,
    ],
    [
        0.084699454,
        '2024-04-27',
        '2024-05-28',
        1,
    ],
    [
        0.084931507,
        '2023-04-27',
        '2023-05-28',
        1,
    ],
    [
        2.085766423,
        '2023-04-27',
        '2025-05-28',
        1,
    ],
    ['#VALUE!', '2023-04-27', 'ABQZ', 1],
    ['#VALUE!', 'ABQZ', '2023-04-07', 1],
    ['#NUM!', '2023-04-27', '2025-05-28', 6],
    ['exception', '2023-04-27', 'omitted'],
    ['exception', 'omitted'],
    [0, null, null],
    // Excel 1900 calendar gets all of the following wrong (null second arg).
    // PhpSpreadsheet is bug-compatible.
    [108, '2007-12-30', null],
    [107.11111111, '2007-02-10', null],
    [107, '2006-12-30', null],
    [107.00277778, '2006-12-31', null],
    [107.00277778, '2007-01-01', null],
    [106.99722222, null, '2006-12-29'],
    [100.419444, '2000-06-01', null, 0],
    [100.419572, '2000-06-01', null, 1],
    [101.883333, '2000-06-01', null, 2],
    [100.487671, '2000-06-01', null, 3],
    [100.419444, '2000-06-01', null, 4],
    [108.555556, '2006-12-29', null, 2],
    [108.558333, '2006-12-30', null, 2],
    [108.561111, '2006-12-31', null, 2],
    [108.563889, '2007-01-01', null, 2],
    [108.566667, '2007-01-02', null, 2],
    // Excel 1900 calendar gets all of the following wrong (null first arg).
    // PhpSpreadsheet is bug-compatible.
    [107, null, '2006-12-30'],
    [107.00277778, null, '2006-12-31'],
    [107.00277778, null, '2007-01-01'],
    [107.00555556, null, '2007-01-02'],
    [107.06849315, null, '2006-12-29', 3],
    [107.07123288, null, '2006-12-30', 3],
    [107.07397260, null, '2006-12-31', 3],
    [107.07671233, null, '2007-01-01', 3],
    [107.07945205, null, '2007-01-02', 3],
    [100.419444, null, '2000-06-01', 0],
    [100.419572, null, '2000-06-01', 1],
    [101.883333, null, '2000-06-01', 2],
    [100.487671, null, '2000-06-01', 3],
    [100.419444, null, '2000-06-01', 4],
];