Legal documents often have clauses that involve precise timeframes.

AllDrafts' calculated fields make it easy for you to include specific dates derived from relative timeframes, adding clarity to documents and eliminating tedious counting.

Here's a list of date calculations commonly encountered, and an example formula for use in a calculated field.

  1. Business Days:

    "Within 10 business days of receiving the notice."

    =WORKDAY(Date_of_Notice, 10, USHOLIDAYS())

    "Payment is due 15 business days from the date of invoice."

    =WORKDAY(Date_of_Invoice, 15, USHOLIDAYS())

    "Notice must be provided at least 5 business days in advance."

    =WORKDAY(Deadline, -5, USHOLIDAYS())

  2. Calendar Days:

    "The agreement will terminate 30 days from the Effective Date."

    =Effective_Date + 30

    "The cure period shall last for 10 days from the date of notice."

    =Date_of_Notice + 10

  3. Months: "Not less than 3 months before the last day of the lease."

    =EDATE(Last_Day_of_Lease, -3)

    "The license shall last for a period of 12 months, commencing on the Start Date."

    =EDATE(Start_Date, 12)

    "The probation period will be for the first six months of employment."

    =EDATE(Start_Date, 6)

    "The lease ends Lease Years from the Start Date."

    =DATE(YEAR(Start_Date)+Lease_Years, MONTH(Start_Date), DAY(Start_Date)-1)

    "Notice of Intent to Renew must be received no later than Notice Months before the end of the lease."

    =EDATE(DATE(YEAR(Start_Date)+Lease_Years, MONTH(Start_Date), DAY(Start_Date)-1),-1*Notice_Months)

  4. Weeks:

    • "The termination notice period is 4 weeks."
    • "The consultation period will be 2 weeks."

  5. Specific Dates:

    • "The obligations under this section will expire on December 31, 2025."
    • "The next review date is set for July 1, 2024."

  6. Anniversary Dates:

    • "On each one-year anniversary of the Effective Date, the parties shall review the terms."
    • "Bonuses will be paid on the six-month anniversary of the commencement of employment."

  7. End of the Month/Quarter/Year:

    • "All reports are due by the end of the fiscal quarter."
    • "Payment will be completed by the end of the current calendar year."
    • "Renewal decisions must be made no later than the last day of the month prior to expiration."

  8. Following Days:

    • "The meeting will be on the third Monday following the signing of this agreement."
    • "The bonuses shall be paid on the first Friday of every quarter."

  9. Commencement/Effective Date References:

    • "This agreement shall commence 10 days after both parties have executed it."
    • "All rights and obligations start from the Effective Date."

  10. Extensions:

  • "The term may be extended for successive one-year periods upon mutual agreement."
  • "Either party may propose a six-month extension, provided written notice is given 45 days before termination."
  1. Holidays and Non-working Days:
  • "If the due date falls on a non-working day or public holiday, the deadline will be extended to the next business day."
  • "Deliverables due on a weekend shall be submitted by the previous Friday."
  1. Days Following Events:
  • "The report is due 7 days after the close of the event."
  • "The final payment shall be made within 15 days post completion of the project."

These are just a few examples, and the specific language might vary based on jurisdictions, the nature of the agreement, and other factors. Always ensure that any contractual timelines are clear to all parties involved to prevent misinterpretation.