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

7 votes172 views3 answers
How to remove public from url in laravel 8
PHP Laravel
2 votes145 views3 answers
Ajax post json data handle in php
PHP
0 vote152 views1 answer
Laravel htaccess for aws ec2
PHP
0 vote119 views1 answer
Chart trong laravel
PHP
0 vote133 views1 answer
Add tag tpo protfolio?
PHP
0 vote123 views1 answer
Cakephp group by count
PHP
12 votes129 views2 answers
Php how to delete file
PHP
0 vote163 views1 answer
Laravel webmix scss
PHP Laravel
0 vote137 views1 answer
Database interaction in codeigniter
PHP
0 vote132 views1 answer
Mamp change php version
PHP