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

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.

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.

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.

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.

Microsoft Word has a date field, but it's not easy to use in an expression. If you need to update dates in a document, use Excel to calculate the dates and then run a mail merge.

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.