# YEARFRAC function

YEARFRAC function in Excel allows you to calculate the fraction of a year between two dates, making it useful for various financial and time-based calculations. It’s a straightforward way to determine the duration between two dates, which can be beneficial for understanding interest accruals, time periods, and more.

## Syntax

YEARFRAC(start_date, end_date, [basis])

## How to use

Let’s see how to use the YEARFRAC function with some examples:

Example 1: Calculate the fraction of a year between two dates:

This formula calculates the fraction of a year between January 1, 2023, and June 30, 2023, using the default basis (US NASD 30/360).

Example 2: Calculate the fraction of a year using a different day count basis:

In this example, the formula calculates the year fraction using the Actual/Actual basis, giving you a more precise result.

Example 3: Calculate the year fraction between two specific dates and explain the basis:

Here, we calculate the year fraction for the entire year 2023, using the “Actual/365 Fixed” basis, which considers the number of days in the year for the calculation.

YEARFRAC is a versatile function that helps you with a wide range of date-related calculations, including interest calculations, time duration, and more.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.