Challenge - 5 Problems
DATE Function Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
📊 Formula Result
intermediate2:00remaining
Calculate the date for the 15th day of the 3rd month in 2025
Which formula correctly returns the date March 15, 2025?
Attempts:
2 left
💡 Hint
Remember the DATE function order is YEAR, MONTH, DAY.
✗ Incorrect
The DATE function takes the year first, then month, then day. Only option D follows this order correctly.
📊 Formula Result
intermediate2:00remaining
Find the date 10 days after January 25, 2024
Which formula returns the date February 4, 2024?
Attempts:
2 left
💡 Hint
Adding days to a date can be done by simple addition.
✗ Incorrect
Adding 10 to the date January 25, 2024, results in February 4, 2024. Option C adds 10 days correctly.
❓ Function Choice
advanced2:00remaining
Choose the formula that returns the last day of February in a leap year
Which formula returns February 29, 2020?
Attempts:
2 left
💡 Hint
Using day 0 of the next month returns the last day of the previous month.
✗ Incorrect
In Excel, day 0 of March 2020 is February 29, 2020, the last day of February in a leap year. Option B uses this trick correctly.
📊 Formula Result
advanced2:00remaining
Calculate the date 45 days before April 10, 2023
Which formula returns the date February 24, 2023?
Attempts:
2 left
💡 Hint
Subtract days by simple subtraction from the date.
✗ Incorrect
Subtracting 45 days from April 10, 2023, results in February 24, 2023. Option A does this correctly.
🎯 Scenario
expert3:00remaining
Determine the weekday of the first day of the current year
Given the current year is 2024, which formula returns the weekday number of January 1, 2024, where Sunday=1 and Saturday=7?
Attempts:
2 left
💡 Hint
Check the WEEKDAY function's return type to match Sunday=1.
✗ Incorrect
The WEEKDAY function with return_type 1 returns Sunday as 1 and Saturday as 7. Option A uses this correctly.