Laravel excel maatwebsite 3.1 import, date column in excel cell returns as unknown format number. How to solve this?

By using Maatwebsite/Laravel-Excel version 3.1 to import excel sheet, here I faced an issue date time column of the excel sheet returns unknown number. How to solve this? Example : Consider Cell value “29/07/1989” and returns as “32178” when import.


The numbers come from excel itself, dates stored in excel as numeric

For Laravel framework 5.6 and maatwebsite/excel package version 3.1,
to convert date from excel numbers to normal date format, this
can be used. It accepts integer(excel date) and returns DateTime

More information can be found here

From this answer: