Excel Dates Showing as Numbers in Power Automate? Fix
You read a row from Excel, and the date column comes back as 46340 instead of a date. Nothing is broken. Excel stores every date as a number, and the Excel Online (Business) connector often hands you that number. Here are the fixes, in the order I use them.
Quick answer
Why Power Automate returns 46340 instead of a date from Excel, plus the exact expressions and one setting that turn it into a real date you can format.
Video transcript
Excel dates showing up as numbers in Power Automate? Here's the fix.
Meet Sophie, office manager at Harbour and Lane in Bristol. Her flow sends rent reminders from an Excel sheet. The sheet says the fourteenth of November. The email says four six three four zero.
First, why. Excel stores every date as a number: the days since the thirtieth of December, eighteen ninety-nine. The connector hands you that number.
Second, try the built-in setting. In List rows, open advanced parameters, and set Date Time Format to I.S.O. eighty-six oh one. Dates come back as real dates.
Third, other actions don't have that setting, so convert it yourself. In a Compose, add the number of days to the thirtieth of December, eighteen ninety-nine, then wrap it in format date time.
Fourth, if the cell has a time, int throws it away. Multiply by the seconds in a day, and use add seconds instead.
Fifth, empty cells. A blank date makes int fail, and the whole flow stops. Check with empty first.
Sixth, a date typed as text isn't a number at all. Fix the column in Excel first.
Sophie runs the flow again. The fourteenth of November. My tip: convert the date once, in a Compose, and reuse it everywhere.
The full guide, with every expression ready to copy, is free at winstack365.com.
1. Why you see a number
Excel keeps a date as the count of days since 30 December 1899, with the time of day as a fraction. So 46340 is a date, and 46340.5 is the same date at noon. The cell looks like a date because of its format, but the connector reads the underlying value.
The fix is to convert that number in the flow. You cannot format it with formatDateTime until it is a real date.
2. Try the built-in setting first
In the List rows present in a table action, open Advanced parameters and add Date Time Format. Choose ISO 8601. Date columns now come back as text like 2026-11-14T00:00:00.000Z instead of a number.
This only exists on List rows present in a table. Get a row and the other actions do not offer it, so for those use the expression in the next section.
3. Convert the number with an expression
Add 1899-12-30 as the start date and add the number of days. Put this in a Compose action, replacing the dynamic content with your own column:
addDays('1899-12-30', int(items('Apply_to_each')?['Due date']))To show it in a format you want, wrap it in formatDateTime:
formatDateTime(addDays('1899-12-30', int(items('Apply_to_each')?['Due date'])), 'dd/MM/yyyy')The start date is 30 December, not 1 January, because Excel counts a day that never existed in 1900. For any date after February 1900, 1899-12-30 gives the right answer.
4. When the cell also has a time
If the number has a decimal part, int() throws the time away. Multiply by the seconds in a day instead and add seconds:
addSeconds('1899-12-30T00:00:00Z', int(mul(float(items('Apply_to_each')?['Start']), 86400)))The result has no real time zone. Excel does not store one. Treat it as the time the user typed, and do not run it through a UTC to local conversion.
5. Handle empty cells
A blank date comes back as an empty string, and int('') makes the flow fail. Check first:
if(empty(items('Apply_to_each')?['Due date']), null, addDays('1899-12-30', int(items('Apply_to_each')?['Due date'])))If your column sometimes holds real text dates and sometimes numbers, test with isInt or a Condition before converting.
6. Dates that come back as text
If the cell was typed or pasted as text, such as 14/11/2026, Excel never made it a date. The number fix will not help. Convert the column to a real date in Excel first, or parse it in the flow with parseDateTime, giving the locale and the format. Fixing the source is better, because the next person who edits the sheet will hit the same problem.
7. Writing a date back to Excel
When you add or update a row, send the date as ISO text such as 2026-11-14 and make sure the column in the Excel table is formatted as a Date. Excel then reads it as a date. Test with one row first. If you see the text in the cell instead, set the column format and try again.
8. Check the table, not just the range
Want this done for you?
I build this for clients every week. Book a free 30-minute call and I'll tell you exactly what your team needs.