Tag: VBA

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.

I’ve always been interested in computers, technology and automating things. But I have no formal education to prove this, I just play around and learn as I go.

Here’s a little background to my (limited) programming background and how I have begun to progress and where I will go from here. This will likely become a series as I progress further into the world of programming.