Excel date format in php

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

Similar codes

12 votes92 views6 answers
Php array remove empty values
PHP
0 vote77 views1 answer
Ajax php call action form
PHP
36 votes91 views6 answers
Get current time in php
PHP
1 vote96 views1 answer
Wp safe redirect
PHP Wordpress
2 votes85 views3 answers
Ternary in php
PHP
3 votes84 views2 answers
Undefined method JeroenNoten\LaravelAdminLte\Helpers\MenuItemHelper::isSearchBar()
PHP
0 vote87 views1 answer
Laravel Excel numbers formatted as text still appearing as number
PHP
2 votes44 views1 answer
Php stdclass is object?
PHP
19 votes117 views6 answers
Laravel logger
PHP Laravel
6 votes95 views3 answers
Php calculate hours and minutes between two times
PHP