Tag: Custom Function

Following the popularity of my blog post last week about How to Calculate the Number of Days Between Two Dates (which even attracted the attention of The Official Twitter Page for Excel!), I am continuing the series with an introduction to the WEEKNUM & ISOWEEKNUM functions.

 

Why Do I Need to Know the Week Number

 

Many companies work to weeks instead of actual dates. This can be for a number of different reasons, but a common reason is so as not to commit to a specific day/date as there can be many factors to consider.