Menu
EXCEL DATE FUNCTION
Excel DATE Function Introduction
This function will create a valid date from the values you supply as Year, Month and Day. Return value will be serial number represents a particular date in Excel (if you change the date format to general you can see the serial number).
Description of Excel DATE Function
Syntax:
=DATE (year, month, day)
Parameter list:
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.
Step By Step Guide of DATE Function
Example :
You may generate an anniversary date based on another cell by using the YEAR, MONTH, and DAY methods. Assume an employee’s first day of work is October 1, 2016; the DATE function may be used to get his five year anniversary date:
Key Points
- The DATE function is used to generate a date.
=DATE(YEAR(C2)+5,MONTH(C2),DAY(C2)) - The YEAR function examines cell C2 and retrieves the year “2012.”
- Then, in cell D2, “+5” adds 5 years, establishing “2017” as the anniversary year.
- The “3” is extracted from C2 using the MONTH function. In cell D2, this establishes “3” as the month.
- “14” is extracted from C2 using the DAY function. In cell D2, this sets “14” as the day.
Excel DATE Function Template/Exercise
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
