YEARFRAC
Date & TimeYEARFRAC helps you perform date and time helpers for scheduling, intervals, and calendar-aware calculations.
Overview
Use YEARFRAC with 3 arguments. Parameter names are currently generalized in this guide.
Parser pathArity-derived docs
Syntax & Arity
=YEARFRAC(arg1, arg2, arg3)
3 required
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| arg1 | Required | Single | Input argument used by this function. |
| arg2 | Required | Single | Input argument used by this function. |
| arg3 | Required | Single | Input argument used by this function. |
Example Inputs & Outputs
Formula
=YEARFRAC(<arg1>, <arg2>, <arg3>)
Example Output
Date or time value
Replace placeholders with your worksheet values or ranges to compute a result.