Subtracting From a Date
Key points
- Enter a negative
- See the formula
- Check it
In Date Offset Builder, a negative number gives an earlier date.
Steps
- Enter a negative
- See the formula
- Check it
You can check the result with a sample date.
Use "Build a Date Offset Formula" (free)
Tools that go well with this
- Calculate Age, Days Between Dates and Date Offsets: Calculate age and days between dates.
- Build a DATEDIF Formula: Build a DATEDIF formula.
- Excel Serial Number and Date Converter: Convert Excel serial numbers and dates.