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.