FRAC.YEAR function

Category:Date and Time

Name in English:YEARFRAC

That makes?

Find the fraction of the year that represents the number of days between two dates.

Syntax

YEAR FRAC (start_date, end_date, base)

  • start_date (required ): The start date of the calculation.
  • end_date (required ): The end date of the calculation.
  • base (optional ): Base type used to count the days [0 = (US) 30/360, 1 = real / real, 2 = real / 360, 3 = real / 365, 4 = (European) 30/360] .

Examples

YEAR FRACTION (“03/15/2012”, “05/23/2012”) = 0.188888889
YEAR FRACTION (“03/15/2012”, “05/23/2012”, 3) = 0.189041096

Leave a Comment