DATE function

Use

To enter a date in a cell, “/”  or “-” characters are used. By default, a month comes first before a date in Excel’s date format. You may also use DATE function to combine three different values (of date, month and year) to form a date.

Syntax

=DATE (year, month, day)

where arguments are:

year –  The year to be used in the date.

month – The month to be used in the date.

day – The day to be used in the date.

Example

Formulas:

Results:

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved