Php

Search

php reader read date from excel

$excel_date = 43010; //here is that value 41621 or 41631
$unix_date = ($excel_date - 25569) * 86400;
$excel_date = 25569 + ($unix_date / 86400);
$unix_date = ($excel_date - 25569) * 86400;
echo gmdate("Y-m-d", $unix_date);

//result is 2017-10-02

Comment

PREVIOUS	NEXT

Code Example
Php :: laravel relationship with for single data
Php :: how to remove public from url in laravel 8
Php :: convert comma separated number to number in php
Php :: php form examples tutorials with code
Php :: array filter use key
Php :: wp-config.php repair
Php :: php convert object to array
Php :: php json request get value
Php :: laravel mongodb delete
Php :: laravel $loop interation
Php :: php check if folder empty
Php :: php get timezone
Php :: laravel select all except some columns
Php :: php is scan dir recursive?
Php :: laravel tinker add user
Php :: how to make a model in folder in laravel
Php :: relative path php
Php :: php change date format from d/m/y to y-m-d
Php :: php sort array by key
Php :: inner join codeigniter
Php :: composer
Php :: php print array
Php :: grenerating random text color for text for image php
Php :: Laravel seed timestamps columns
Php :: laravel random record
Php :: add custom user meta and display it in user page
Php :: php check of object is empty
Php :: curl header log php
Php :: case inside laravel query
Php :: laravel get db connection info

Search

PHP

php reader read date from excel

ADD CONTENT