The english function name YEARFRAC() has been translated into 17 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
Availability
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Date & Time |
| Excel 2013 | Yes | Date & Time |
| Excel 2010 | Yes | Date & Time |
| Excel 2007 | Yes | Date & Time |
| Excel 2003 | No | - |
Reference language
| Language | Designation |
|---|---|
| English | YEARFRAC |
Translations
| Language | Designation |
|---|---|
| Catalan | FRAC.AÑO |
| Danish | ÅR.BRØK |
| Dutch | JAAR.DEEL |
| Finnish | VUOSI.OSA |
| French | FRACTION.ANNEE |
| Galician | FRACCIÓNANO |
| German | BRTEILJAHRE |
| Hungarian | TÖRTÉV |
| Italian | FRAZIONE.ANNO |
| Norwegian | ÅRDEL |
| Polish | CZĘŚĆ.ROKU |
| Portuguese, Brazil | FRAÇÃOANO |
| Portuguese, Portugal | FRAÇÃOANO |
| Russian | ДОЛЯГОДА |
| Spanish | FRAC.AÑO |
| Swedish | ÅRDEL |
| Turkish | YILORAN |
Different translations for Excel 2010 SP1
| Language | Designation |
|---|---|
| Portuguese, Portugal | FRACÇÃOANO |
Different translations for Excel 2010
| Language | Designation |
|---|---|
| Portuguese, Portugal | FRACÇÃOANO |
Links to the Microsoft Online Help for the function YEARFRAC()
Note: Microsoft is currently updating the links and contents for the Excel online help. Therefore, some of the following links may not work as expected and lead to an error page. The links will on this site will be updated as soon as possible.