Start free

Interview quiz track

First 2 free Junior Excel

Excel – Date Functions

Practice Excel date function interview questions covering TODAY, DATE, YEAR, MONTH, and date calculations. Answer questions and receive feedback on correctness and approach. Ideal for data analyst and operations interview prep. First 2 questions are free with full feedback.

  • Level Junior
  • Questions 12
  • date functions

Try any track free — first 2 questions include full AI feedback. Subscribe to finish the track and unlock everything. Type or speak your answer — the first 2 questions include scoring and detailed AI feedback.

Try first 2 questions free All tracks

Sample excel – date functions interview questions

Preview 6 questions from this track in quiz order. In the full quiz you answer one at a time — type or speak — then get a score and feedback.

  1. How do you get today’s date in Excel?

    What a strong answer includes

    Uses TODAY().

  2. How do you extract the year from a date?

    What a strong answer includes

    Uses YEAR.

  3. How do you calculate the number of days between two dates?

    What a strong answer includes

    Subtracts the dates.

  4. How do you add 30 days to a date?

    What a strong answer includes

    Adds 30 to the date cell.

  5. What does the DATE function do?

    What a strong answer includes

    Creates a date from year, month, and day.

  6. How do you get the month name from a date?

    What a strong answer includes

    Uses TEXT function.