date function

Description

This is the build in function in excel that allows you to create a date from individual year, month and day components. This function is useful when required to integrate with other functions like SUMIFS or COUNTIFS. It is because you could easily assemble a date using year, month and day values that come from a cell reference of formula result.

​

Objective

Able to generate a valid date from year, month and day.

​

Syntax

=DATE(year,month,day)

​

Arguments

year - The year to use when creating the date.

month - The month to use when creating the date.

day - The day to use when creating the date.