Excel Function

DATE

Builds a date from year, month, day.

DATE(year, month, day)

Arguments

year

Required

Enter a numeric value.

month

Required

Enter a numeric value.

day

Required

Enter a numeric value.

Practice Preview

calculate and display date/time values. Use DATE to Builds a date from year, month, day. use 2026 for year, use 3 for month, use 8 for day. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=DATE(2026, 3, 8)

Practice This Function

Practice in Sequential Mode Back to Function List