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 vote265 views1 answer
How to use db more than 1 codeigiter 3
PHP
0 vote303 views1 answer
Php sort custom function
PHP
0 vote385 views1 answer
Laravel 8 template favicon
PHP Laravel
0 vote387 views1 answer
Get post by name wordpress
PHP Wordpress
5 votes308 views3 answers
Mobile number validation in laravel 8
PHP
0 vote341 views1 answer
Multiple laravel site in one directory
PHP Laravel
4 votes316 views4 answers
Extract Numbers From a String in PHP
PHP
3 votes317 views2 answers
Laravel carbon created_at date in current month
PHP
25 votes298 views6 answers
Php combine arrays
PHP
0 vote305 views1 answer
Mysqli php 7.4
PHP