The DATE function is useful in situations where the year, month, and day need to be used in other formulas and for converting dates that have been entered/imported into a worksheet that are not in a format that Excel recogonizes.

DATE takes 3 required arguments and no optional arguments:

Syntax: DATE(year, month, day)

#1)
Undertanding how Excel stores dates as serial numbers:
#2)
Using the DATE function:
#3)
The arguments for the DATE function are:
Argument Required? Description
year Required The year argument can include one to four digits.
month Required A positive or negative integer representing the month of the year from 1 to 12 (January to December).
day Required A positive or negative integer representing the day of the month from 1 to 31.

Summary

The DATE function is useful in situations where the year, month, and day need to be used in other formulas and for converting dates that have been entered/imported into a worksheet that are not in a format that Excel recogonizes. The important thing is to become comfortable with the concept of how Excel views dates as serial numbers.
comments powered by Disqus