Correct negative dates or times in Excel

When Excel shows ##### because the cell has a negative date or time value, make sure that you:

• Verify dates and times are positive values when you’re using the 1900 date system.
• Use a formula to subtract dates or Add or subtract time correctly to avoid negative date or time value results.

• Change negative formula results that are formatted as dates or times to a different number format.