What is WEEKNUM?
Returns the week number of a specific date. Essential for weekly reporting and planning.
Syntax
=WEEKNUM(serial_number, [return_type])
Example
Formula: =WEEKNUM(\
Result: 11
How It Works
Returns week 11 for March 15, 2024. Return_type defines which day starts the week.