Date & Time
In the following an alphabetically sorted list of all Excel functions for the category Date & Time of the current version of Microsoft Excel as well as their translations in the selected language. Please note, that in earlier versions of Excel the translations may be different. A detailed list of the translations for each function from Microsoft Excel 2010 and above can be found in the linked article.
Translations
| Product | Microsoft Excel (Office 365) |
| Category | Date & Time |
| Source language | English |
| Target language |
| D | German |
|---|---|
| DATE | DATUM |
| DATEVALUE | DATWERT |
| DAY | TAG |
| DAYS | TAGE |
| DAYS360 | TAGE360 |
| E | German |
|---|---|
| EDATE | EDATUM |
| EOMONTH | MONATSENDE |
| H | German |
|---|---|
| HOUR | STUNDE |
| I | German |
|---|---|
| ISOWEEKNUM | ISOKALENDERWOCHE |
| M | German |
|---|---|
| MINUTE | MINUTE |
| MONTH | MONAT |
| N | German |
|---|---|
| NETWORKDAYS | NETTOARBEITSTAGE |
| NETWORKDAYS.INTL | NETTOARBEITSTAGE.INTL |
| NOW | JETZT |
| S | German |
|---|---|
| SECOND | SEKUNDE |
| T | German |
|---|---|
| TIME | ZEIT |
| TIMEVALUE | ZEITWERT |
| TODAY | HEUTE |
| W | German |
|---|---|
| WEEKDAY | WOCHENTAG |
| WEEKNUM | KALENDERWOCHE |
| WORKDAY | ARBEITSTAG |
| WORKDAY.INTL | ARBEITSTAG.INTL |
| Y | German |
|---|---|
| YEAR | JAHR |
| YEARFRAC | BRTEILJAHRE |