EDATE, EOMONTH, WORKDAY

Freebeginner 15 min4 tasks0/60 pts

EDATE moves a date by whole months. EOMONTH returns the last day of the month (optionally some months away). WORKDAY adds working days, skipping weekends. They are the backbone of due dates and billing cycles.

Syntax

EDATE(start, months) · EOMONTH(start, months) · WORKDAY(start, days)

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.

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.

DATE Functions Skill Summary WEEKDAY and NETWORKDAYS

Topics/Date Functions

EDATE, EOMONTH, WORKDAY

Freebeginner 15 min4 tasks0/60 pts

Syntax

EDATE(start, months) · EOMONTH(start, months) · WORKDAY(start, days)

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.

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.

DATE Functions Skill Summary WEEKDAY and NETWORKDAYS