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 |