These functions extract specific information from a date.
Example Data
|
Date |
|
28-Sep-2026 |
|
15-Aug-2026 |
|
01-Jan-2026 |
DAY
Syntax
=DAY(A2)
Returns:
28
MONTH
Syntax
=MONTH(A2)
Returns:
9
YEAR
Syntax
=YEAR(A2)
Returns:
2026
WEEKDAY
Syntax
=WEEKDAY(A2)
Returns a number representing the day of the week.
For example, with the default numbering:
- Sunday = 1
- Monday = 2
- Tuesday = 3
- etc.
WEEKNUM
Syntax
=WEEKNUM(A2)
Returns the week number of the year.
Practical Table
|
Date |
Day |
Month |
Year |
Weekday |
Week No. |
|
28-Sep-2026 |
|||||
|
15-Aug-2026 |
|||||
|
01-Jan-2026 |
Practice
Create a Monthly Date Analysis Sheet using all five functions.