When we are working with dates in Excel, we might wish to know in which week of the year, this date falls. For example, what if I want to know in which week of the year my birthday comes?. This is going to be a very long calculation if I started counting the weeks from the beginning of the year. Thankfully, we don’t have to do it by ourselves when Excel has introduced the WEEKNUM Function.
In this tutorial we would learn how to calculate the week number of the date using the WEEKNUM formula in excel.
Here we go 😎
When to Use WEEKNUM Function of Excel
The word WEEKNUM represents “Week Number”. The function finds the number of the week on which a particular date falls. There are 365 days in a year (366 if leap year). When we divide 364 by 7 we get 52 complete years. The left 2 days might fall in the beginning or at the end of 52 complete weeks making the function to return the week number from 1 to 54.
The WEEKNUM formula forms part of the Date/Time Excel Function group.