If you've ever started up a Mac that sat unplugged for long enough to discharge the battery that backs up its memory of the current date and time, you've seen the date January 1, 1904, replace the ...

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.

How to convert a birth date to an age without an expression using Microsoft Excel Power Query Your email has been sent Calculating age requires a bit of specialized knowledge. Any expression you use ...

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. Tech blogger Chandoo points out the =networkdays ...