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.

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

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.

If you change the date, Excel will then update the calculation. You'll need to use in the identifier for the cell containing the date, such as A1, H4 and C12.

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

Please note: This item is from our archives and was published in 2001. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Okay, so Excel is a ...

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.

Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates.

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier.