Excel makes it easy to find how many days there are between two dates. With a little more effort, you can find the number of days in which people will be actually working.

DAYS and DAY360 functions calculate days. In this tutorial, we are going to discuss how to use DAYS and DAYS360 functions in Excel.

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.

You already knew that Excel can do straight date math, but it can also take into account holidays to find the number of working days between two dates.

Since each date is really just a number stored in Excel, to compute the midpoint of two dates you would use the same mathematical formulas you would use to calculate the midpoint of two numbers ...

How to exclude holidays in Excel So far, we’ve used NETWORKDAYS () to exclude weekends when counting the number of days between today and the estimated completion date for our projects.

A TechRepublic member wrote for advice on calculating the years, months, and days elapsed between two dates. This tutorial explains the solution provided by TechRepublic contributor Jeff Davis.