YEARFRAC

Return the fraction of the year represented by the number of whole days between two dates.

Date & TimeYEARFRAC(start_date, end_date, [basis])
In progress

This page is being built.

We're authoring YEARFRAC from scratch with a real workplace scenario, hand-tuned Excel mockups, the four mistakes that trip everyone up, and a mastery track of practice exercises. Check back soon.

Browse other functions
YEARFRAC Excel Function | CellSkill