YEARFRAC

Date & timeExcel 2007

The fraction of a year between two dates (for interest, tenure, age).

Syntax

YEARFRAC(start_date, end_date, [basis])

Examples

=YEARFRAC(A2, TODAY())

→ 3.61

Related functions

DATEDIF DAYS

More Date & time functions

DATE DATEDIF DATESTRING DATEVALUE DAY DAYS DAYS360 EDATE EOMONTH HOUR ISOWEEKNUM MINUTE

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.