YEARFRAC
Returns the year fraction representing the number of whole days between start_date and end_date.
Date & TimeDates & Time Calculations
What it does
Calculates the fraction of a year between two dates.
Syntax
YEARFRAC(start_date, end_date, [basis])
Arguments
start_date(date) — Start.end_date(date) — End.
Examples
Year Fraction
Fraction of year passed.
FORMULA
=YEARFRAC("2023-01-01", "2023-07-01")RESULT
0.5
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 0.5 |