Please enable JavaScript to view the comments powered by Disqus.


YEARFRAC(...B4,B5)

Calculate number of years between two dates

This formula takes the starts date and end date as argument and gives the numbers of years in between the dates.


Used Functions

Category: Date and time

Returns the year fraction representing the number of whole days between start_date and end_date

Syntax

YEARFRAC(start_date, end_date, [basis])

Lets chat on this