Blog Archives

Getting Complex with Dates – Part 2

Having dealt with normal date calculation, and then working days, it’s time to look at some of the other date functions that are often used. This week, we’ll look at Weekday.  Here’s a scenario: If you want to check some dates to

Posted in Uncategorized Tagged with:

Getting Complex with Dates

After last week’s note about dates, a few people asked me about different ways to deal with dates and calculations. Excel has a variety of different functions to use, and the most commonly used is NETWORKDAYS.  The syntax for the

Posted in Uncategorized Tagged with:

Dates and Excel

When teaching Excel classes, invariably the subject of dealing with dates crops up. Excel can be used to calculate dates. Firstly though, you need to know how to enter the date so that Excel knows that a date is being

Posted in Uncategorized Tagged with: