One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.

As a result, using the WEEKDAY function to calculate days of the week for dates in 1900 before March 1 yields incorrect results in Microsoft Excel worksheets built using the 1900 date system.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.

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.

One way to correct this behavior is to change your default date system. On the Mac version of Excel, you can do this within the calculation pane of Excel's preferences.

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.