YEARFRAC function

description:

Returns the year fraction.

 

syntax:

=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.