YEARFRAC function in Excel

Use

To get a fractional value representing fractional years between two dates, YEARFRAC function is used. For example, by using the function, you can get a fractional year of 0.5 in a separate cell from two dates of 30-Jun-2016 and 31-Dec-2016.

Syntax

=YEARFRAC(start_date, end_date, [basis])

start_date – The start date

end_date – The end date

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

Basis Day count basis
0 or omitted US (NASD) 30/360
1 Actual/actual
2 Actual/360
3 Actual/365
4 European 30/360

Example

Formula

:

Results:

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved