EDATE function - Zoho Sheet - Help Guide

EDATE

Returns the date-serial number that is the given number of months away or before the specified date. The day of the month remains unchanged, unless it is more than the number of days in the new month.

 

Syntax

 

EDATE(start_date; months)

start_date: The date to which you want to add/remove the given number of months. E.g. "3/2/2020"

months: The number of months to add/remove. Counts backwards if negative. E.g. 1

 

Remarks

  • The result can be formatted to display the date.


Examples

 

Formula

Result

=EDATE("3/2/2020";1)

43923

=EDATE("1/1/2020";5)

6/1/20

=EDATE("1/1/2020";-2)

43770


Get a hands-on experience of the function in the embedded range below.  



Possible Errors

 

Errors

Meaning

#N/A!

  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.

#NAME!

  • The function name is incorrect or invalid.

  • The given defined name (if any) is invalid.

  • There is a typo in the defined name used in the function.

  • Double quotes are missing for text values in the function.

  • Colon missing in a cell range reference.

#VALUE!

  • The given argument's data type is incorrect or invalid.
    For example, the function =DATE(A1:A3) will return a #VALUE error when a text value is present in the range.

#REF!

  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.

 

Similar Functions