This article describes the formula syntax and usage of the YEARFRAC function in Microsoft Excel.

Description

YEARFRAC calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). For instance, you can use YEARFRAC to identify the proportion of a whole year’s benefits, or obligations to assign to a specific term.

Syntax

YEARFRAC(start_date, end_date, [basis])

The YEARFRAC function syntax has the following arguments:

BasisDay count basis
0 or omittedUS (NASD) 30/360
1Actual/actual
2Actual/360
3Actual/365
4European 30/360

Important: 

Remarks

Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

DataDescription
1/1/2012Start date
7/30/2012End date
FormulaDescriptionResult
=YEARFRAC(A2,A3)Fraction of the year between 1/1/2012 and 7/30/12, omitting the Basis argument.0.58055556
=YEARFRAC(A2,A3,1)Fraction between same dates, using the Actual/Actual basis argument. Because 2012 is a Leap year, it has a 366 day basis.0.57650273
=YEARFRAC(A2,A3,3)Fraction between same dates, using the Actual/365 basis argument. Uses a 365 day basis.0.57808219

Leave a Reply

Your email address will not be published. Required fields are marked *

Open chat
1
ভর্তি/সার্টিফিকেট তথ্য জানতে ক্লিক করুন
Scan the code
আস সালামু আলাইকুম। বিস্তারিত জানতে/ কল করতে ক্লিক করুন Open Chat বাটনে