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 |
| TODAY |
TODAYTODAY () |
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 |