EDATE and EOMONTH in Excel - 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.

Excel

=EDATE(A1, [1])

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

A0

B5

C-3

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using a negative number to add months.

Using zero which returns the same date.

The EDATE function adds a specified number of months to a date. Here, 3 months are added to the date in A1.

2fill in blank

medium

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

Excel

=EOMONTH(B2, [1])

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

A2

B-2

C1

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 instead of 2 for months.

Using negative numbers which go backward.

EOMONTH returns the last day of the month, offset by the number of months. Here, 2 months after B2.

3fill in blank

hard

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

Excel

=EDATE(C3, [1])

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

A0

B-1

C1

D2

Attempts:

3 left

💡 Hint

Common Mistakes

Using positive 1 which adds a month.

Using zero which returns the same date.

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

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.

Excel

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

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

A-4

B1

C0

D-1

Attempts:

3 left

💡 Hint

Common Mistakes

Using positive 4 which goes forward.

Adding 1 or -1 which changes the date.

EOMONTH with -4 finds the last day 4 months before D4. Adding 0 keeps that 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 subtracts 5 days.

Excel

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

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

A6

B0

C5

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong numbers for months or days.

Adding days instead of subtracting.

First, EDATE adds 6 months to E5. Then EOMONTH with 0 finds the last day of that month. Finally, subtract 5 days to get the date 5 days before month end.