Loading…
Loading…
EOMONTH returns the last day of the month, months away.
=EOMONTH(start_date, months)
| Argument | Required? | What it is |
|---|---|---|
| start_date | Required | The earlier date. |
| months | Required | How many months to move forward (negative to go back). |
=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.
Type the formula yourself and get it graded instantly, no Excel needed.