FAQs

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.

It’s been a while since my last blog. So to get back into it, I thought I’d start a short series to answer some of the common, simple Excel questions that I am asked.

 

If you know me, you will know that I love a spreadsheet and can often be found using formulas and VBA to create awesome spreadsheets to automate and simplify everyday tasks.

In the office, it’s not uncommon to hear “Joe, can you help me with this formula?” or “Joe, how do I do this in Excel” or “Joe, Help! Please fix this spreadsheet for me!”

Of course, being the helpful geek that I am, I not only find a solution to the question in hand but usually offer fast improvements overall as well.

 

How do I work out how many work days are between two dates?

 

Calculating the days between two dates in Excel is very simple and I am sure that even an Excel Novice can come up with = Last_Date – First_Date to calculate the number of days between the two dates.