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

3 votes293 views6 answers
Php hello world program
PHP
0 vote321 views1 answer
Send OTP php
PHP
0 vote313 views1 answer
MySQL eqSql Connection
PHP
0 vote404 views1 answer
Laravel migration add contraint to other database
PHP Laravel
1 vote337 views1 answer
Php laravel string substring
PHP Laravel
0 vote306 views1 answer
Count number of rows laravel controller
PHP
2 votes332 views4 answers
Laravel redirect action
PHP Laravel
0 vote322 views1 answer
Php arrow function
PHP
0 vote301 views1 answer
ForPage return keys on page 2
PHP
-1 vote297 views2 answers
Toast in php
PHP