Formulas > =EDATE()
How To Use EDATE() Function in Google Sheets
Description
How To Actually Use EDATE() in Sheets
EDATE(start_date, months)
Try EDATE yourself
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.
Hints (2)
-
Remember to reference the correct cell in column B.
-
Make sure to drag the formula down to fill the range C1:C10.
1 Better Sheets Tutorial
Ben Asks: How Do I Add 1 Month?
Member Ben asks how to add 1 month to a date.
CONCATENATE()
EDATE()
TEXT()
TODAY()
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.
Generate a EDATE() formula