When #NUM! Appears
Key points
- Check the dates
- Fix the order
- Try again
A #NUM! from a formula built in DATEDIF Builder means the start date is later than the end date.
Steps
- Check the dates
- Fix the order
- Try again
Try swapping the two dates.
Use "Build a DATEDIF Formula" (free)
Tools that go well with this
- Excel Serial Number and Date Converter: Convert Excel serial numbers and dates.
- Calculate Age, Days Between Dates and Date Offsets: Calculate age and days between dates.
- Build an IF Formula: Build an IF formula.