Excel Connector Dates turned into Integers. How to solve it?

Power Automate Excel Connector Dates

When you have a Flow which needs to extract dates from an excel spreadsheet, and email them out or update a SharePoint list, the imported data is returned as plain numbers instead as dates, even though the cells themselves are formatted as dates.

For example the date 06/18/12 is being read in as 41078. So, how to solve it?

That pretty easy to transform it:

addDays('1899-12-30',int(items('Apply_to_each')?['Date']))

Note: There’s a reason to use 1899-12-30 and not 1900-01-01. For some reason, when using 1900-01-01, flow is adding two more days to the expected result.