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 vote162 views1 answer
Laravel bootstrap-auth setup
PHP
0 vote210 views1 answer
Sass download for windows
PHP
0 vote203 views3 answers
Laravel select default old value
PHP Laravel
9 votes174 views6 answers
Post request jquery
PHP
4 votes183 views2 answers
Wp get_posts return ids
PHP Wordpress
0 vote149 views1 answer
Quitar elemento array php
PHP
0 vote185 views1 answer
Connect another database in wordpress
PHP Wordpress
3 votes156 views2 answers
Set php var to html
PHP
0 vote154 views1 answer
Git reset head 3 . how to back git init
PHP
1 vote196 views2 answers
Laravel 8
PHP Laravel