SheetFX
≡
<< Go back to all functions

EDATE

The EDATE function in Google Sheets is a powerful tool to return a date that is a specified number of months before or after another date. Whether you're calculating future dates, analyzing financial data, or planning project timelines, the EDATE function simplifies the task. Explore our detailed guide to learn how to use this function effectively.

Function Syntax and Parameters

Syntax: EDATE(start_date, months)

Parameters:

  • start_date: The starting date from which the calculation is based.

  • months: The number of months to move forward or backward from the start_date.

Step-by-Step Tutorial

  1. Using EDATE to calculate future dates:

    • Example: =EDATE("2022-01-01", 3)
    • Result: 2022-04-01

  2. Using EDATE to calculate past dates:

    • Example: =EDATE("2022-01-01", -2)

    • Result: 2021-11-01

Use Cases and Scenarios

  1. Financial Planning: Determine the maturity date for an investment.
  2. Project Scheduling: Calculate the deadline for a task based on its start date and duration.
  3. Rent Payments: Determine the due date for rent based on the start date of the lease agreement.

Related Functions

  • DATE: Create a date from separate day, month, and year values.

  • EOMONTH: Find the last day of the month a specified number of months before or after another date.

  • TODAY: Get the current date.

Related Articles