Better Sheets

How to Use EDATE() in Google Sheets

Description

Returns a date a specified number of months before or after another date.

How To Actually Use EDATE() in Sheets

EDATE(start_date, months)

In cells B1:B10, enter a start date. In cells C1:C10, use the EDATE formula to calculate the date that is 3 months after each start date in column B.

Your formula

Hints (2)

Locale Separator ,

1 Better Sheets Tutorial

Member Ben asks how to add 1 month to a date.

Intermediate

CONCATENATE() EDATE() TEXT() TODAY()

Transcript-matched member videos for EDATE(). Click through to watch.

What is "&" doing in this formula? MONTH(A1&1) Do you know why this is s...

CONCAT() DATE() MONTH() VALUE()

Figure out how many days between two days, or how many days until a cert...

Intermediate

DATE() DATEDIF()

Learn more about the EDATE() formula:

Generate a EDATE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses EDATE(). 2 free AI generations, no signup. Members get unlimited use.

More related tutorials