How to Write EDATE and WORKDAY (Build Them Automatically, Free)
Key points
- Enter the cell
- Enter the number
- Copy the formula
Date Offset Builder builds a formula from a date cell and months or days.
Steps
- Enter the cell
- Enter the number
- Copy the formula
The formula can be pasted straight into a cell.
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.