PHPOffice / PhpSpreadsheet

        return require 'data/Calculation/DateTime/DATE.php';

    }

    public function testDATEtoPHP()

    {

        Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC);

        $result = DateTime::DATE(2012, 1, 31);

        Functions::setReturnDateType(Functions::RETURNDATE_EXCEL);

        $this->assertEquals(1327968000, $result, null, 1E-8);

    }

    public function testDATEtoPHPObject()

    {

        return require 'data/Calculation/DateTime/DATEVALUE.php';

    }

    public function testDATEVALUEtoPHP()

    {

        Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC);

        $result = DateTime::DATEVALUE('2012-1-31');

        Functions::setReturnDateType(Functions::RETURNDATE_EXCEL);

        $this->assertEquals(1327968000, $result, null, 1E-8);

    }

    public function testDATEVALUEtoPHPObject()

    {

        return require 'data/Calculation/DateTime/TIME.php';

    }

    public function testTIMEtoPHP()

    {

        Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC);

        $result = DateTime::TIME(7, 30, 20);

        Functions::setReturnDateType(Functions::RETURNDATE_EXCEL);

        $this->assertEquals(27020, $result, null, 1E-8);

    }

    public function testTIMEtoPHPObject()

    {

        return require 'data/Calculation/DateTime/TIMEVALUE.php';

    }

    public function testTIMEVALUEtoPHP()

    {

        Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC);

        $result = DateTime::TIMEVALUE('7:30:20');

        Functions::setReturnDateType(Functions::RETURNDATE_EXCEL);

        $this->assertEquals(23420, $result, null, 1E-8);

    }

    public function testTIMEVALUEtoPHPObject()

    {

        return require 'data/Calculation/DateTime/EDATE.php';

    }

    public function testEDATEtoPHP()

    {

        Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC);

        $result = DateTime::EDATE('2012-1-26', -1);

        Functions::setReturnDateType(Functions::RETURNDATE_EXCEL);

        $this->assertEquals(1324857600, $result, null, 1E-8);

    }

    public function testEDATEtoPHPObject()

    {

        return require 'data/Calculation/DateTime/EOMONTH.php';

    }

    public function testEOMONTHtoPHP()

    {

        Functions::setReturnDateType(Functions::RETURNDATE_PHP_NUMERIC);

        $result = DateTime::EOMONTH('2012-1-26', -1);

        Functions::setReturnDateType(Functions::RETURNDATE_EXCEL);

        $this->assertEquals(1325289600, $result, null, 1E-8);

    }

    public function testEOMONTHtoPHPObject()

    {