Multiple choice

Which of the following is the correct date function?

  1. =DATE(2008:12:25)

  2. =DATE(2008,12,25)

  3. =DATE(25,12,2008)

  4. DATE(2008:12:25)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The DATE function in Excel requires three comma-separated arguments in the order: year, month, and day. Option B correctly shows DATE(2008,12,25) using commas as separators. Options A and D incorrectly use colons (:) which are not valid parameter separators in Excel functions. Option C has the parameters in the wrong order (day, month, year).

Keep practicing — related questions