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. 

More Info

List of all supported available connectors for Microsoft Power Automate here.

Read more about Power Automate and let us know if you need any help with it, just drop us an email.