EDATE and EOMONTH in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the EDATE function do in Google Sheets?

EDATE returns a date that is a specified number of months before or after a given start date. It helps you find a date exactly months away.

beginner

How does EOMONTH differ from EDATE?

EOMONTH returns the last day of the month, a specified number of months before or after a start date. EDATE returns the exact date months away, not necessarily month-end.

beginner

Write the formula to find the date 3 months after January 15, 2024 using EDATE.

EDATE(DATE(2024,1,15), 3) will return April 15, 2024.

intermediate

What will EOMONTH(DATE(2024,2,10), 0) return?

It returns February 29, 2024, the last day of February 2024 (leap year).

intermediate

Why use EOMONTH when calculating due dates or billing cycles?

Because EOMONTH gives the last day of a month, it helps set deadlines or billing dates that fall exactly at month-end, avoiding confusion with mid-month dates.

What does EDATE(A1, 2) do if A1 contains 2024-01-10?

A Returns 2024-02-29

B Returns 2024-01-31

C Returns 2024-03-10

D Returns 2024-03-31

EDATE adds 2 months to January 10, 2024, resulting in March 10, 2024.

Which function returns the last day of the month?

A EOMONTH

B EDATE

C TODAY

D DATE

EOMONTH returns the last day of the month for a given date.

What will EOMONTH(DATE(2024,1,15), 1) return?

A February 15, 2024

B January 31, 2024

C March 31, 2024

D February 29, 2024

It returns the last day of the month one month after January 15, 2024, which is February 29, 2024 (leap year).

If you want to find the date 6 months before today, which formula is correct?

A EDATE(TODAY(), -6)

B EOMONTH(TODAY(), -6)

C EDATE(TODAY(), 6)

D EOMONTH(TODAY(), 6)

EDATE with -6 subtracts 6 months from today.

What is the output of EOMONTH(DATE(2024,12,10), 0)?

A December 10, 2024

B December 31, 2024

C January 31, 2025

D November 30, 2024

EOMONTH with 0 returns the last day of the same month, December 31, 2024.

Explain how EDATE and EOMONTH functions differ and give one example use case for each.

Think about exact dates versus month-end dates.

Describe how you would use EOMONTH to find the last day of the next month from today.

Remember EOMONTH counts months from the start date.