Calculating the Number of Days or Weeks

You can use the Calculated field to calculate the number of days and weeks.
You use field codes in formulas.

  • When calculating the number of days from the start date to the end date of the Date field
    Specify as follows in the Calculated field.
    Formula: (End Date - Start Date) / (60 * 60 * 24)
    Show As: Number
    Number of Decimal Places to Display: 0
    Unit of measure: days (Suffix)

  • When calculating the number of weeks from the start date to the end date of the Date field
    Specify as follows in the Calculated field.
    Formula: (End Date - Start Date) / (60 * 60 * 24 * 7)
    Show As: Number
    Number of Decimal Places to Display: 0
    Unit of measure: weeks (Suffix)