Filter by Categories
Select all
Budget
Business Statements
Calendars
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Inventory
Investments
Invoice/ Bill
Maintenance
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Quotation
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
UAE VAT
UK VAT
Filter by File Types






Excel Date Functions : WEEKNUM

How to use WEEKNUM Function in MS Excel

Introduction to WEEKNUM Function

WEEKNUM function returns the week number of a date. In simple words, WEEKNUM returns the week number of dates that you specify ranging from 1 to 54.

Download Sample File

Download Sample Files to work, practice and master the Date Functions in Excel.

Syntax of WEEKNUM Function

WEEKNUM(serial_number,return_type)

Arguments of WEEKNUM Function

  • serial_number: A date for which you want to get the week number.
  • [return_type]: A number to specify the starting day of the first week of the year. You have two systems to specify the starting date of the week.

Example of WEEKNUM Function in MS Excel

In the below example, we have used TODAY with WEEKNUM to get the week number of the current date. It will update the week number automatically every time the date changes.

In the below example, we have added the text “Week-” with the week number for a meaningful result.

Other Excel Date Functions Tutorials

You can explore and master other date functions in Microsoft Excel. Here is a complete list of date functions available in Microsoft Excel.

Content

Macro Codes in Excel

Learn Excel Quickly
Get full list of Excel Macro Codes