Explanation
Excel stores dates as serial numbers, which allows dates to be used in calculations.
For example:
=DATE(2026,9,28)
returns:
28-Sep-2026
Important Date & Time Functions
|
Function |
Purpose |
|
TODAY |
Returns current date |
|
NOW |
Returns current date and time |
|
DATE |
Creates a date from year, month and day |
|
DAY |
Extracts day |
|
MONTH |
Extracts month |
|
YEAR |
Extracts year |
|
WEEKDAY |
Returns day-of-week number |
|
WEEKNUM |
Returns week number |
|
EDATE |
Adds/subtracts months |
|
EOMONTH |
Returns month-end date |
|
DATEDIF |
Calculates difference between dates |
|
NETWORKDAYS |
Counts working days |
|
WORKDAY |
Calculates a working-day date |
Practice
Create a table with:
|
Employee |
Joining Date |
|
Amit |
15-Jan-2024 |
|
Neha |
20-Mar-2023 |
|
Rahul |
10-Jul-2025 |
Use date functions to extract the year, month and day.