Excel Function – WEEKNUM 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?

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?

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