Challenge - 5 Problems
EDATE and EOMONTH Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
📊 Formula Result
intermediate2:00remaining
Calculate Date 3 Months Ahead Using EDATE
If cell A1 contains the date
2024-01-15, what will be the result of the formula =EDATE(A1, 3)?Attempts:
2 left
💡 Hint
EDATE adds the number of months to the date in A1, keeping the day number if possible.
✗ Incorrect
The formula =EDATE(A1, 3) adds 3 months to January 15, 2024, resulting in April 15, 2024.
📊 Formula Result
intermediate2:00remaining
Find Last Day of Month 2 Months Before Using EOMONTH
If cell B2 contains the date
2024-06-10, what is the result of =EOMONTH(B2, -2)?Attempts:
2 left
💡 Hint
EOMONTH returns the last day of the month, offset by the number of months.
✗ Incorrect
=EOMONTH(B2, -2) finds the last day of the month two months before June 2024, which is April 30, 2024.
❓ Function Choice
advanced2:00remaining
Choose the Correct Formula to Find the Last Day of Next Month
Which formula correctly returns the last day of the month after the date in cell C3?
Attempts:
2 left
💡 Hint
EOMONTH returns the last day of the month offset by months; EDATE returns the same day number offset by months.
✗ Incorrect
=EOMONTH(C3, 1) returns the last day of the month after the month of the date in C3.
🎯 Scenario
advanced2:00remaining
Calculate Subscription Expiry Date 6 Months Later on Last Day of Month
You have a subscription start date in cell D4. You want to find the expiry date exactly 6 months later, but always on the last day of that month. Which formula should you use?
Attempts:
2 left
💡 Hint
EOMONTH returns the last day of the month offset by months.
✗ Incorrect
To get the expiry date 6 months later on the last day of that month, use =EOMONTH(D4, 6).
❓ data_analysis
expert2:00remaining
Analyze Formula Output for End of Month with Negative Offset
Given the date
2024-03-31 in cell E5, what is the output of =EOMONTH(E5, -1)?Attempts:
2 left
💡 Hint
Remember 2024 is a leap year with 29 days in February.
✗ Incorrect
=EOMONTH(E5, -1) returns the last day of the month one month before March 2024, which is February 29, 2024 (leap year).