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 vote89 views1 answer
Php get from second character of string to middle
PHP
1 vote129 views1 answer
How to remove jstream package
PHP
0 vote119 views1 answer
Get stock product woocommerce by id
PHP
2 votes124 views2 answers
Php mb_convert_case
PHP
3 votes129 views3 answers
Php remove after character
PHP
0 vote118 views1 answer
Alphabet, link, range
PHP
0 vote178 views1 answer
Disable cors laravel
PHP Laravel
18 votes117 views6 answers
Php sort multidimensional array by key
PHP
0 vote138 views1 answer
Fichier wp-config.php
PHP
0 vote127 views1 answer
Php header x-powered-by
PHP