WEEKNUM Function in Google Sheets

Determine the week number of a given date using the WEEKNUM function.

WEEKNUM Function

The WEEKNUM function in Google Sheets returns the week number of a specific date.

Syntax

WEEKNUM(date, [type])
  • date: The date for which to determine the week number.
  • type (optional): Specifies when weeks start. Defaults to 1 (weeks start on Sunday).

Examples

  1. Basic Usage

To find the week number for "2024-08-15":

=WEEKNUM("2024-08-15")
  1. Using a Different Start Day

To find the week number with the week starting on Monday:

=WEEKNUM("2024-08-15", 2)

Notes

  • The type parameter allows you to define the start of the week differently (e.g., Monday, Tuesday).
  • Useful in tracking weekly progress or events.
  • ISOWEEKNUM: Returns the ISO week number of the year.
  • DATE: Returns a date based on year, month, and day.