Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Let’s Talk 💬
  • Add-Ons

weeknum

WEEKNUM Function – Google Sheets

August 25, 2023January 13, 2018 Adam Steinfurth

The WEEKNUM function accepts a date and returns the week number (1 through 54) of that date. The date must be in a valid format, so you have to use the DATE function, wrap it in quotes, or use a cell reference to a date. If your days, months, and years are in different cells, … Read more

Categories Date parts Tags date, function, months, subtract, weeknum, weeks, years
StaySorted moving a row automatically

Get the Google Sheets Add-On
  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2025 Sheets Help • Built with GeneratePress