Home › Excel formulas › Date and Time functions
Excel Date and Time Functions: Full List with Examples
Date and time functions build dates, calculate ages and working days, and return today or now. They are used in HR, finance and project sheets. Open any function for its syntax, arguments, a worked example and a free practice spreadsheet.
| Function | What it does |
|---|---|
| TODAY | Returns today's date, updated automatically. |
| NOW | Returns the current date and time. |
| DATE | Builds a real date value from separate year, month, and day numbers. |
| DATEDIF | Calculates the difference between two dates in days, months, or years. |
| DAY | Pulls just the day number out of a date. |
| MONTH | Pulls just the month number out of a date. |
| YEAR | Pulls just the year out of a date. |
| WEEKDAY | Returns which day of the week a date falls on, as a number. |
| WEEKNUM | Returns which week of the year a date falls in. |
| EOMONTH | Returns the last day of the month, a set number of months away. |
| EDATE | Returns a date a set number of months before or after a start date. |
| NETWORKDAYS | Counts working days between two dates, excluding weekends. |
| WORKDAY | Returns the date a set number of working days from a start date. |
| TIME | Builds a time value from separate hour, minute, and second numbers. |
| HOUR | Pulls just the hour out of a time value. |
| ISOWEEKNUM | Returns the ISO week number of the year for a date. |
| DATEVALUE | Converts a date stored as text into a real date value. |
| TIMEVALUE | Converts a time stored as text into a real time value. |
| DAYS | Returns the number of days between two dates. |
| DAYS360 | Returns days between two dates based on a 360-day year. |
| YEARFRAC | Returns the fraction of a year between two dates. |
| NETWORKDAYS.INTL | Counts working days between two dates with a custom weekend. |
| WORKDAY.INTL | Returns a future/past workday with a custom weekend. |
| MINUTE | Pulls just the minute out of a time value. |
| SECOND | Pulls just the second out of a time value. |
| DATEDIF + TODAY | Finds how many days have passed between a fixed start date and today, updating automatically every day. |
| EOMONTH + TODAY | Finds the last day of the current month, automatically staying current as the month changes. |
| NETWORKDAYS + IF | Counts working days between two dates using NETWORKDAYS, then classifies the result with IF. |
| WEEKDAY + IF (weekend check) | Uses WEEKDAY to get a date's day-of-week number, then IF to classify it as a weekend or weekday. |
| YEAR + MONTH (period key) | Combines YEAR and MONTH into a single sortable text label like '2026-03' for grouping data by month. |
Practice Date and Time functions free
Type formulas in a real spreadsheet and get instant feedback.
Start practice → Formulas cheat sheetFrequently asked questions
What are the main Excel Date and Time functions?
Cellgrids lists 30 Excel Date and Time functions. Popular ones include TODAY, NOW, DATE, DATEDIF, DAY. Each has its own page with syntax, arguments and an example.
How can I practice Excel Date and Time functions online?
Open the free live spreadsheet on Cellgrids, type the function in a cell and check your answer. No Excel install or sign-up is needed to start.
Which Excel Date and Time function should a beginner learn first?
Start with TODAY. Returns today's date, updated automatically.