DATEVALUE

Converts a date in the form of text to a serial number.


Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Shared/ZipStreamWrapper.php on line 84

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Shared/String.php on line 530

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Shared/String.php on line 531

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Shared/String.php on line 537

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Shared/String.php on line 537

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Shared/String.php on line 538

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Shared/String.php on line 538

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Worksheet/AutoFilter.php on line 726

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Worksheet/AutoFilter.php on line 726

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2103

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2103

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2211

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2211

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2213

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2266

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2268

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2550

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2676

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2678

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2679

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2954

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2954

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2957

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 2958

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 3372

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 3372

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 3407

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 3411

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 3464

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation.php on line 3465

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 754

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 755

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 758

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 759

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 759

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 761

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 762

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 762

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 762

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell.php on line 766

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86

Warning: The PHPExcel DATEVALUE() function accepts a wider range of date formats than MS Excel's DATEFORMAT() function.

Date String Formula Excel DateStamp Formatted DateStamp
26 March 2012=DATEVALUE(A1)
Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation/Functions.php on line 311

Deprecated: Array and string offset access syntax with curly braces is deprecated in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation/Functions.php on line 527

Fatal error: 'break' not in the 'loop' or 'switch' context in /var/www/testing/PHPExcel_1.7.8/Classes/PHPExcel/Calculation/Functions.php on line 574