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 /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 529

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 530

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 536

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 536

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 537

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 537

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2186

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2186

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2294

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2294

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2296

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2372

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2374

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2383

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2632

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2761

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2763

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2764

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3039

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3039

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3042

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3043

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3459

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3459

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3501

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3505

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3558

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3559

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 729

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 729

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 772

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 773

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 776

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 777

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 777

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 779

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 780

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 780

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 780

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 784

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/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 /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation/Functions.php on line 311

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation/Functions.php on line 313

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation/Functions.php on line 534

Fatal error: 'break' not in the 'loop' or 'switch' context in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation/Functions.php on line 581