YEARFRAC function. Get the percentage of the period between the two dates in a year.(Microsoft Excel)
Get the percentage of the period between the two dates in a year.
Contents
How it works
=YEARFRAC(Start_date, End_date, Basis)
| Argument | Omission | Specify |
|---|---|---|
| Start_date | Required argument. | Start date of the calculation. |
| End_date | Required argument. | End date of calculation. |
| Basis | 0 | Calculation Method. |
Basis
| Basis | Calculation Method. |
|---|---|
| 0 | 30days / 360days (NASD) |
| 1 | Actual days / Actual days |
| 2 | Actual days /360days |
| 3 | Actual days /365days |
| 4 | 30days / 360days (European method) |
Example Results
The following cases are also calculated without a sign.
- End date is more past.
- The year crosses over.
---