Learn Excel EasyDaily One Lesson

Quiz › Dates & Times › Date maths

Date maths: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

  1. A1 has 15-Aug-2026. What will this formula return?
    =YEAR(A1)
    • A. 2026
    • B. Aug
    • C. 15
    • D. 8
    Show the answerA — 2026. YEAR pulls the year out of a date.
  2. A1 has 15-Aug-2026. What will this formula return?
    =MONTH(A1)
    • A. 8
    • B. August
    • C. 2026
    • D. 15
    Show the answerA — 8. MONTH gives the month as a number. August is 8.
  3. A1 has 15-Aug-2026. What will this formula return?
    =A1+7
    • A. 22-Aug-2026
    • B. An error
    • C. 15-Sep-2026
    • D. 15-Aug-2033
    Show the answerA — 22-Aug-2026. Dates are day counts, so +7 moves one week ahead.
  4. A1 has 1-Jan-2026 and B1 has 31-Jan-2026. What will this formula return?
    =B1-A1
    • A. 30
    • B. An error
    • C. 31
    • D. 1
    Show the answerA — 30. Subtracting two dates gives the days between them: 30.
  5. A1 has 15-Aug-2026. What will this formula return?
    =DAY(A1)
    • A. 2026
    • B. 15
    • C. Saturday
    • D. 8
    Show the answerB — 15. DAY gives the day of the month as a number: 15.

Want to learn this? Read the Dates & Times lessons →
← More Dates & Times topics · All quiz categories