Excel date conversion using PHP Excel

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 putting 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);

More Related Contents:

  1. Reading an Excel file in PHP [closed]
  2. Convert the FULL Excel date serial format to Unix timestamp
  3. How to get static data member from php object instance? [closed]
  4. Generate all possible 4 digit numbers in PHP and concatenate them with a string [closed]
  5. Are PDO prepared statements sufficient to prevent SQL injection?
  6. Laravel csrf token mismatch for ajax POST Request
  7. Preventing Directory Traversal in PHP but allowing paths
  8. Using PHP with Socket.io
  9. How to create an array from a CSV file using PHP and the fgetcsv function
  10. Is it possible to overwrite a function in PHP
  11. Diagnosing Memory Leaks – Allowed memory size of # bytes exhausted
  12. Laravel migration: unique key is too long, even if specified
  13. Which $_SERVER variables are safe?
  14. Laravel Eloquent select all rows with max created_at
  15. Advantages Of MySQLi over MySQL [closed]
  16. How to schedule the execution of a PHP script on the server side?
  17. Dynamically display a CSV file as an HTML table on a web page
  18. ucfirst() function for multibyte character encodings
  19. How to get all combinations from multiple arrays?
  20. PHP APIs for Hotmail, Gmail and Yahoo? [closed]
  21. MySQL Error “Too many connections”
  22. php count xml elements
  23. Difference between var_dump,var_export & print_r
  24. How to run a cronjob every X minutes?
  25. Using json_encode on objects in PHP (regardless of scope)
  26. Which coding style you use for ternary operator? [closed]
  27. How to post multiple as array in PHP?
  28. Find and replace in a file
  29. Laravel /broadcasting/auth Always Fails With 403 Error
  30. Symfony\Component\HttpKernel\Exception\NotFoundHttpException Laravel

Leave a Comment