WEEKNUM
Converts a serial number to a number representing where the week falls numerically with a year.
Date & TimeDates & Time CalculationsMost Used
What it does
Returns the week number for a date (depends on the numbering system).
Syntax
WEEKNUM(serial_number, [return_type])
Arguments
serial_number(date) — Date to evaluate.
Examples
Week number
Return the week number for the date in A2.
FORMULA
=WEEKNUM(A2,2)
RESULT
(varies)
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2026-01-05 |
| 3 | 2026-12-31 |