In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory, ...

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000, which is the only version that explains how this function works.

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as complicated as it ...

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. A ...