Why does my date show as a number in Excel?
Formula (Excel and Google Sheets)
=B2+C2Dates are stored as serial numbers, and the result cell has a number format. Keep the formula, like =B2+C2, and format the cell as a date.
- Result on the example
- one result per row in
D2, filled down toD6 - Works in
- Every current version
- Google Sheets
- Same formula
See it work
The formula is already in D2, filled down to D6. Change any input and the result updates, or edit the formula to experiment.
How it works
Dates are stored as serial numbers: 46326 is October 31, 2026. Adding 30 days to a date gives another serial number, and in a cell with the General or Number format that is what you see. Formatted as a date, the same value shows as 10/31/2026.
=B2+C2Result46326
B210/1/2026The value in B2.
C230The value in C2.
B2+C246326The + operator adds.
In Google Sheets
The same formula works in Google Sheets: =B2+C2. We ran it in Google Sheets mode on the same data and it returns the same results.
Other ways to do it
Each one was run on the same example sheet.
| Formula | Result | When to use it |
|---|---|---|
| =WORKDAY(B2,C2) | 11/12/2026, 10/26/2026, 12/14/2026…Different result | Counts working days instead of calendar days. The due dates land later, skipping weekends. |
| =TEXT(B2+C2,"m/d/yyyy") | 10/31/2026, 10/20/2026, 11/26/2026…Different result | Returns the date as text in a fixed format, for joining into messages. Text, not a date value: it no longer sorts or calculates as a date. |
Common mistakes
- The fix is the cell format (Ctrl+1, Date), not a different formula.
- Wrapping the date in TEXT makes it look right but turns it into text that won't sort or subtract properly.
- A number in the 40,000s is a date. A small one, like 30, may be a day count wrongly formatted as a date.
Try it yourself
Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.
Why does my date show as a number
D2, add the payment terms to the invoice date to get the due date. The cell is formatted as a date. Fill down to D6.Questions
Why does Excel store dates as numbers?
So you can calculate with them: subtracting two dates gives the days between them.
How do I show the weekday too?
Use a custom format such as ddd m/d/yyyy, or =TEXT(D2,"dddd") for the day name.
Checked by running on 2026-10-30: every formula and result on this page was calculated by the Spreadsheet Practice formula engine, in both Excel and Google Sheets modes.