WEEKNUM

WEEKNUM helps you calculate and analyze date-related data by returning week numbers in AirSheet worksheets. It provides the tools you need to enter formulas efficiently and work with flexible parameters, making your work more efficient and helping you accomplish tasks with ease. With WEEKNUM, you can type the formula directly in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use it in different calculation scenarios, reference data across worksheets, and include it in nested calculations with automatic recalculation when source data changes. Whether you're checking formula syntax, correcting parameter or reference issues, or manually triggering recalculation when results seem incorrect, WEEKNUM helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53