YEARFRAC function


Returns the year fraction.



=YEARFRAC( start_dateend_date[basis] )


required arguments:

start_date The start date.
end_date The end date.


optional arguments:

[basis] The type of day count basis to use.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.