How to get Week number Excel Function

Excel Function – WEEKNUM

Excel Function – WEEKNUM

How to get Week number Excel Function

WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date.

Syntax:
=Weeknum(serial_number,[return_type])

Video Tutorial – How to use WEEKNUM Excel Function?

This video covers:

How to get Week Number of the year from Date in Excel?
How to get Week Number of the Month from Date in Excel?
How to get Week number Excel Function

Please do share this video and share your view in the below comments box.

Author:
Excelsirji.com was started with the thought of making people experience easy while working with Excel, data analytics, vba, automations etc.

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you a Data Enthusiast?

Join us for a ride on your data and automate your stuffs