Time & life
Calculation method and formula
absolute value(End date − Start date) ÷ 30.436875
Understand the inputs
- Start date
- Enter a valid calendar date. Start/end-day conventions are explained below.
- End date
- Enter a valid calendar date. Start/end-day conventions are explained below.
Assumptions and limitations
Calendar days are not working days. Date distance is the day difference without an extra end day; month values explicitly use an average month length. Time zones and holidays are not added.
The formula uses the specified units. Displayed numbers are rounded; whole packs, item counts and full time periods may also be rounded within the calculation.