DATE function


Creates a date from a year, month and day.



=DATE( yearmonthday )


required arguments:

year A number that represents a year.
month A number that represents a month.
day A number that represents a day.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.