# YEARFRAC

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the fraction of the year represented by the number of whole days between the start and end dates.

## Syntax

YEARFRAC(*startdate*,*enddate*,*basis*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *startdate* | Starting date (DateTime object) |
| *enddate* | Ending date (DateTime object) |
| *basis* | [Optional] Integer representing the basis for day count (Refer to [Day Count Basis](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsfinance/formulas-functsdaycount).) |

## Remarks

This functions returns an error when start, end, or basis is invalid.

## Data Types

Accepts numeric, string, DateTime object data for the date arguments and numeric data for the optional argument. Returns numeric data.

## Examples

`YEARFRAC(A1,A2,A3)`

## Version Available

This function is available in product version 2.0 or later.

## See Also

[DATE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDATE) \| [MONTH](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMONTH) \| [TODAY](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionTODAY) \| [YEAR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionYEAR) \| [Date and Time Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsdatetime)