Excel Rate Function Serial Date To

It needs to have the same params as the excel function: RATE( numberpayments, payment, PV, FV, Type, Estimate ).

FV, Type and Estimate seem to be optional as they take default values.

Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.

One use for Excels DATEDIF function is to calculate a persons current age.

If you dont feel like dragging out a calendar, a simple spreadsheet formula can come to the rescue.

Alternatively, use the function to compute the difference between any two dates.

In the following formula, the DATEDIF function determines a persons current age in years, months and days.

To make the formula easier to work with, a persons birth date is entered into cell E1 of a worksheet (see the example below).

The cell reference to this location is entered into the formula.

If the birth date is stored in a different cell in the worksheet, the three cell references in the formula need to be changed.

The formula uses DATEDIF three times to calculate first the number of years, then the number of months, and then the number of days between the two dates.

Number of Years: DATEDIF(E1,TODAY(),Y) Years, Number of Months: DATEDIF(E1,TODAY(),YM) Months, Number of Days: DATEDIF(E1,TODAY(),MD) Days.

For example, the ampersand joins the DATEDIF function to the text Years, Months, and Days in the three sections of the formula.

The formula also makes use of the TODAY() function to enter the current date into the DATEDIF formula.

Excel Rate Function Serial Date To

Since the TODAY() function uses the computers serial date to find the current date, the function continually updates every time a worksheet is recalculated.

The persons current age increases when the worksheet is opened unless automatic recalculation is turned off.

This example of the DATEDIF function calculates your current age.

Excel Rate Function For Mac