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 vote239 views1 answer
Mysql_fetch_array php
PHP
7 votes266 views1 answer
Laravel eloquent date range
PHP Laravel
13 votes258 views6 answers
How to run laravel project
PHP
1 vote228 views1 answer
Run jobs laravel
PHP
0 vote250 views1 answer
Php on page query
PHP
0 vote231 views1 answer
Laravel set innodb scema builder
PHP
0 vote225 views1 answer
How to wp create post type in wordpress
PHP
0 vote216 views1 answer
Php css not updating
PHP
0 vote219 views1 answer
How to add a additional condition in a join using query builder laravel 5.3?
PHP
0 vote222 views1 answer
Disconnect with button click php
PHP