DATE Function in Excel 2010

The DATE function returns the sequential serial number that represents a particular date.

FUNCTIONS	Description / Example	Results
DATE function	Returns the serial number of a particular date
=DATE(year,month,day)	=DATE(1980,8,15)	8/15/1980
=DATE(YEAR(TODAY()),12,31)	Serial date for the last day of the current year.	12/31/2013
=DATE(LEFT(A4,4),MID(A4,5,2), RIGHT(A4,2))	A formula that converts a date from the YYYYMMDD format to a serial date. Ex: 20130515	5/15/2013
=DATEVALUE("mm/dd/yyyy")	Serial number of the text date, using the 1900 date system. =DATEVALUE("07/12/2013")	41467
=DATEVALUE("dd-mm-yyyy")	=DATEVALUE("12-Jul-2013")	41467
DAY Function
=DAY(serial_number)	12-Jul-2013	12
=DAYS360(start_date,end_date,[method])	Number of days in years Star date: 11/1/2010 and end date: 8/2/2013 =DAYS360(DATE(2010,11,1),DATE(2013,8,2))	991
= HOUR(serial_number)	The time that contains the hour you want to find	11
=MINUTE(serial_number)	The time that contains the minute you want to find.	7
=SECOND(serial_number)	The time that contains the seconds you want to find.	59
=MONTH(serial_number)	The date of the month you are trying to find.	12
=YEAR(serial_number)	The date of the year you want to find. =YEAR(TODAY())-1980	33
=NOW()	Returns the serial number of the current date and time	12/5/2013 11:07
TODAY function
=TODAY()	Returns the current date.	12/5/2013
=TODAY()+5	Returns the current date plus 5 days. For example, if the current date is 7/10/2013, this formula returns 7/15/2013.	12/10/2013
=DATEVALUE("1/1/2030")-TODAY()	Returns the number of days between the current date and 1/1/2030. Note that cell A4 must be formatted as General or Number for the result to display correctly.	1/27/1916
=DAY(TODAY())	Returns the current day of the month (1 - 31).	5
=MONTH(TODAY())	Returns the current month of the year (1 - 12). For example, if the current month is June, this formula returns 7.	12
=WEEKDAY(serial_number,[return_type])	=WEEKDAY("7/10/2013",2)	3