YEARFRAC

YEARFRAC function in Excel: Year fraction between two dates.

November 5, 2026

Date & Time function · Excel

YEARFRAC function

Year fraction between two dates.

Platform	Status
Excel	Listed
Google Sheets	Listed

Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.