How many working days between dates

Please purchase the course before starting the lesson.

If you have valid Excel dates you can easily work out how many working days there are between 2 dates.

As shown below if we want to work out the number of working days in 2009 we can use the NETWORKDAYS function.

NETWORKDAYS

Are Saturday/ Sunday always the weekend

As with the WORKDAY function, there is a new version which allows for other days to be the weekend.

NETWORKDAYS

To see the full course contents click here.

Back to: Intermediate Excel Course > Date functions and issues