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/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 526

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 527

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 538

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 539

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 541

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Shared/String.php on line 542

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2551

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2551

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2672

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2672

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2676

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2764

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2768

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 2780

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3034

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3166

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3168

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3169

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3457

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3457

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3460

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3461

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3891

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3891

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3936

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3942

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3998

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 4001

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 720

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 720

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 812

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 813

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 816

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 817

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 817

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 819

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 820

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 820

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 820

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell.php on line 824

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 90

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 90

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/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation/Functions.php on line 321

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation/Functions.php on line 324

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation/Functions.php on line 562

Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation/Functions.php on line 612
40994
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Mar-26
29 Feb 2012=DATEVALUE(A2)40968
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Feb-29
April 1, 2012=DATEVALUE(A3)41000
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Apr-01
25/12/2012=DATEVALUE(A4)41268
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Dec-25
2012-Oct-31=DATEVALUE(A5)41213
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Oct-31
5th November=DATEVALUE(A6)45966
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2025-Nov-05
January 1st=DATEVALUE(A7)45658
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2025-Jan-01
April 2012=DATEVALUE(A8)41000
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Apr-01
17-03=DATEVALUE(A9)45733
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2025-Mar-17
03-2012=DATEVALUE(A10)40969
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2012-Mar-01
29 Feb 2011=DATEVALUE(A11)40603
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2011-Mar-01
03-05-07=DATEVALUE(A12)37748
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2003-May-07
03-MAY-07=DATEVALUE(A13)39205
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2007-May-03
03-13-07=DATEVALUE(A14)41340
Notice: Trying to access array offset on value of type null in /home/netshopview/console.shopview.net/third_party/PHPExcel/Classes/PHPExcel/Calculation.php on line 3349
2013-Mar-07