EDATE and EOMONTH in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to add 3 months to the date in cell A1 using EDATE.

Google Sheets

=EDATE(A1, [1])

Drag options to blanks, or click blank then click option'

A6

B1

C3

D-3

Attempts:

3 left

💡 Hint

Common Mistakes

Using a negative number to add months.

Using 1 instead of 3 for months.

The EDATE function adds a specified number of months to a date. To add 3 months, use 3 as the second argument.

2fill in blank

medium

Complete the formula to find the last day of the month 2 months after the date in B2 using EOMONTH.

Google Sheets

=EOMONTH(B2, [1])

Drag options to blanks, or click blank then click option'

A2

B1

C-2

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 0 which returns the last day of the current month.

Using a negative number which moves backward.

EOMONTH returns the last day of the month, offset by the number of months given. To get 2 months after, use 2.

3fill in blank

hard

Fix the error in the formula to subtract 1 month from the date in C3 using EDATE.

Google Sheets

=EDATE(C3, [1])

Drag options to blanks, or click blank then click option'

A-1

B1

C0

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using positive 1 which adds a month instead of subtracting.

Using 0 which returns the same date.

To subtract months, use a negative number. Here, -1 subtracts one month from the date.

4fill in blank

hard

Fill both blanks to create a formula that finds the last day of the month 4 months before the date in D4.

Google Sheets

=EOMONTH(D4, [1]) + [2]

Drag options to blanks, or click blank then click option'

A-4

B0

C1

D-1

Attempts:

3 left

💡 Hint

Common Mistakes

Adding 1 or -1 which changes the date incorrectly.

Using positive 4 which moves forward instead of backward.

EOMONTH with -4 finds the last day 4 months before. Adding 0 keeps the date unchanged.

5fill in blank

hard

Fill all three blanks to create a formula that adds 6 months to E5, then finds the last day of that month, and finally adds 2 days.

Google Sheets

=EOMONTH(EDATE(E5, [1]), [2]) + [3]

Drag options to blanks, or click blank then click option'

A6

B0

C2

D-6

Attempts:

3 left

💡 Hint

Common Mistakes

Using negative months in EDATE which subtracts instead of adds.

Using non-zero offset in EOMONTH which changes the month.

Adding wrong number of days.

First, EDATE adds 6 months. Then EOMONTH with 0 finds the last day of that month. Adding 2 days moves the date forward by 2 days.