Convert the FULL Excel date serial format to Unix timestamp

by

Please use this formula to change from Excel date to Unix date, then you can use “gmdate” to get the real date in PHP:

UNIX_DATE = (EXCEL_DATE - 25569) * 86400

and to convert from Unix date to Excel date, use this formula:

EXCEL_DATE = 25569 + (UNIX_DATE / 86400)

After doing this formula into a variable, you can get the real date in PHP using this example:

$UNIX_DATE = ($EXCEL_DATE - 25569) * 86400;
echo gmdate("d-m-Y H:i:s", $UNIX_DATE);

Thanks.

More Related Contents:

  1. Reading an Excel file in PHP [closed]
  2. Excel date conversion using PHP Excel
  3. inserting information and image in php and mysql
  4. CodeIgniter – foreach loop
  5. I want to make my password to contain lowercase, uppercase, 8 characters and a character
  6. Project Links do not work on Wamp Server
  7. How to save a PNG image server-side, from a base64 data URI
  8. PHP Warning: PHP Startup: Unable to load dynamic library
  9. What is the “->” PHP operator called? [closed]
  10. How do I make this preg_match case insensitive?
  11. Coalesce function for PHP?
  12. Is it necessary to declare PHP array before adding values with []?
  13. Explode a string to associative array without using loops? [duplicate]
  14. What does a successful MySQL DELETE return? How to check if DELETE was successful?
  15. PHP Header Redirect in a new window?
  16. How to add some textfield in form register (laravel generator infyom)?
  17. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  18. PHP foreach by reference causes weird glitch when going through array of objects
  19. Keep Duplicates while Using array_diff
  20. mysqli query results to show all rows
  21. Fatal error: Declaration of .. must be compatible with .. PHP
  22. How can I echo the whole content of a .html file in PHP?
  23. How to define a Laravel route with a parameter that contains a slash character
  24. Paypal SandBox IPN always returns INVALID
  25. How to get an option previously set with curl_setopt()?
  26. session_start() takes VERY LONG TIME
  27. Using curl in php with client certificate and private key in separate files
  28. Connecting to websocket with PHP client
  29. Get the last modified date of a remote file
  30. jQuery Mobile: Sending data from one page to the another

Leave a Comment