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.

Microsoft Excel handles temporal data effectively if you know which formulas to use. The problem is that Excel includes over 20 date and time functions, but most people only ever need a small core set ...

When you enter a date in one format on a Microsoft Excel worksheet and then want to change the order of the day, month and year, try accessing the Format Cells options. Update the format to help make ...

When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to display date information the way you want it to ...

There’s more to EOMONTH() in Microsoft Excel than the last day of the month. Learn how to put it to use in your spreadsheets. Dates play a part in many spreadsheets, but they can be a bit mysterious, ...

DATEVALUE is a Date and Time function, and its purpose is to convert a date in the form of text to a serial number. In this post, we will show you how to use the DATEVALUE function in Microsoft Excel.