Skip to content
home

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.

Daniel AwokunleDaniel AwokunleUpdated 18 November 2026 4 min read
Watch first: the whole guide in 100 secondsFull steps below
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.

Free: the Microsoft 365 clean-up checklist

The 12 checks I run before building anything in a client's tenant: security, sharing, files and quick wins. Two pages, PDF.

Used only to send the checklist and the odd useful tip. Never shared or sold.

Daniel Awokunle · replies within a day

Tell me what's slowing your team down.

Thirty minutes, no cost, no pitch deck. You'll leave knowing exactly what to build and what it should cost.

Book a free 30-min call
  1. Step 1

    Free 30-min call

    Show me the problem. I'll tell you what I'd build and how long it takes.

  2. Step 2

    Clear quote

    A fixed price and timeline in writing, usually within a day.

  3. Step 3

    Built and handed over

    Built in your own Microsoft 365, with a walkthrough for your team.