To calculate the number of days between today and 04 September 2022 (which is a past date), we will use the formula =TODAY ()-A17. The function returns 24 as the resultant value.

The MOD function returns a remainder from a division and, since Excel handles time as a fraction of a day, this formula will determine the total number of days using the NETWORKDAYS function then ...

Calculate the difference between two values in your Microsoft Excel worksheet. Excel provides one general formula that finds the difference between numbers, dates and times.

Fortunately, Excel offers a built-in function, DATEDIF, which makes it easy to calculate elapsed calendar time.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

The final function calculates the differences in months and days without the years and shows the date with “d.” Now you know how to calculate age in Excel. Please only use your powers for good.