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

0 vote163 views2 answers
Wordpress single post template
PHP
0 vote164 views1 answer
Internal server error phpmyadmin
PHP
3 votes179 views1 answer
Check file size validation laravel
PHP Laravel
3 votes180 views3 answers
Php remove last element array
PHP
0 vote122 views1 answer
Concat object php
PHP
0 vote162 views1 answer
How to set no cache header php
PHP
2 votes169 views3 answers
Ternary in php
PHP
0 vote159 views2 answers
Carbon add 3 hours
PHP
1 vote199 views1 answer
Boot method laravel
PHP Laravel
0 vote198 views1 answer
Laravel route limit parameter
PHP Laravel