EDATE function in Excel

Syntax

=EDATE(start_date, months)

Example

=EDATE(B2,1) is one month later. =EOMONTH(B2,0) is the end of that month. =WORKDAY(B2,10) is 10 working days later.

From the lesson EDATE, EOMONTH, WORKDAY.

Common mistakes

• Adding 30 to move a month: months have different lengths, use EDATE.
• Forgetting WORKDAY skips weekends but not public holidays unless you pass a holiday list.

Related date functions

• DATEBuilds a date from year, month and day.
• TODAYReturns today's date.
• DATEDIFDifference between two dates in "Y", "M" or "D".
• DAYSNumber of days between two dates.
• EOMONTHLast day of the month, months away.
• WORKDAYDate a number of working days away.
• YEARReturns the year of a date.
• MONTHReturns the month of a date.