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:
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.