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 vote346 views1 answer
Wordpress pass parameters variables arguments to enqueued script
PHP Wordpress
0 vote336 views1 answer
Take and skip in laravel
PHP Laravel
0 vote262 views1 answer
How to auto increment id after delete value in php mysql
PHP
1 vote280 views2 answers
Laravel gmail
PHP
0 vote278 views1 answer
Laravel vreeze
PHP
1 vote268 views1 answer
Make model controller with resource
PHP
0 vote300 views1 answer
Publish spatie
PHP
0 vote263 views1 answer
Use middleware in controller to have access session
PHP
0 vote273 views1 answer
Include string special in php
PHP
0 vote364 views1 answer
Get user avatar wordpress
PHP Wordpress