What the Units Mean
Key points
- Choose the unit
- See the formula
- Check it
In DATEDIF Builder you can choose the units Y, M, D, YM, MD and YD.
Steps
- Choose the unit
- See the formula
- Check it
YM is the months excluding years.
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.