Convert number to date

Question

Good afternoon,

I wonder if there is a way to convert number to date in PHP.

Example, in Excel the number 42873 is equivalent to date 18-05-2017. And I have how to do the opposite too.

Is there a function in PHP, to which I can make this conversion?

Answer 1

Dates in Excel are stored in number of days from 1 January 1900, so for dates after this period you can create an object DateTime and format the date for display, example:

$n = 42873;
$dateTime = new DateTime("1899-12-30 + $n days");
echo $dateTime->format("d/m/Y");

Ideone example

Check out this reply on SOE

Answer 2

string date ( string $format [, int $timestamp ] )

The optional timestamp parameter is a Unix timestamp integer whose default is the local time if timestamp is not reported. In other words, the default is the value of the time function().

See more about the date.
More information in this reply.

Answer 3

Some systems export dates to excel already in excel date format. Since Dates in Excel are stored in number of days from January 1, 1900, based on one of the answers to that topic.

I suggest using the CARBON library:

$dt_number = intVal($dado['data']);
if (is_numeric($dt_number)) {
    $dt = new Carbon('1899-12-30');
    $dt = $dt->addDays($dt_number);
}