A function in Excel is a preset formula, that helps perform mathematical, statistical, and logical operations. Worksheet functions are categorized by their functionality.

Date & Time Function

To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon). You can also enter a date and a time in one cell.

Functions Syntax Tutorial
DATE DATE(year,month,day) Example
DAY DAY(serial_number) Example
MONTH MONTH(serial_number) Example
YEAR YEAR(date) Example
DAYS DAYS(end_date, start_date) Example
NOW NOWNOW() Example
DATEVALUE DATEVALUE(date_text) Example
EOMONTH EOMONTH(start_date,month) Example
WORKDAY WORKDAY(start_day, days, [holiday]) Example
WORKDAY.INTL WORKDAY.INTL(start_day, days, [weekend], [holiday]) Example
EDATE EDATE(start_date,month) Example