German dates put the day first, use dots as separators, and pad single digits with a leading zero. That order is the opposite of the US month-first habit, which is exactly why conversions go wrong.
How it works
The German numeric format is DD.MM.YYYY: two-digit day, dot, two-digit month, dot, four-digit year. So 5 March 2026 is 05.03.2026. In sentences, German uses the ordinal with the month name: am 5. Marz 2026, written with the month name and a dot after the day number. For systems and databases, the ISO format YYYY-MM-DD is preferred, and you convert it to DD.MM.YYYY only for display.
Step by step
- Identify the day, month, and year of your starting date, and confirm which number is the month if the source is ambiguous.
- Pad day and month to two digits with a leading zero where needed.
- Write day, dot, month, dot, four-digit year.
- For US input MM/DD/YYYY, swap the first two numbers before reformatting.
- For ISO input YYYY-MM-DD, move the year to the end and the day to the front.
- For written German, use the day ordinal, a dot, and the month name: am 5. Marz 2026.
Worked example
US date 03/05/2026 means 5 March 2026 in US month-first order, which becomes 05.03.2026 in German format. ISO date 2026-11-20 becomes 20.11.2026. A date with single digits, 1 February 2026, becomes 01.02.2026, not 1.2.2026, in formal German writing. In a sentence: Der Termin ist am 1. Februar 2026.
Common mistakes
- Copying a US date straight across without swapping day and month. 03/05 means March 5 in the US and 3 May in German day-first reading.
- Dropping the leading zeros, which looks informal and can break fixed-width systems.
- Using slashes instead of dots in German formal writing.
- Writing the year with two digits in official documents, where four digits are expected.
Try it with the free tool
You can follow every step above by hand, but the free tool below does the same calculation instantly. Try your own numbers in it, then check one result by hand so you trust the method as well as the answer. Open the full tool here: open the tool.
Checklist before you finish
- Write down every input number first, with its unit, before you calculate anything.
- Work through the steps in order, and do not skip the unit conversions.
- Check the answer against the worked example above: is it the right size, and does the direction make sense?
- Round only at the end, and keep the unrounded figure for any follow-up calculation.
Practice with your own numbers
Pick three cases of your own and work each one by hand. First, try a simple round-number case you can check mentally. Second, try a realistic case with awkward numbers, the kind you will actually meet. Third, try an edge case, such as a very small or very large input, and confirm the answer still behaves sensibly. If any case gives a surprising result, re-check the units and the formula step by step before you trust it.
If your answer looks wrong
Most errors come from a small set of causes. Check that you used the same units throughout, that you divided where the formula divides and multiplied where it multiplies, and that you applied any percentage as a decimal. Check the order of operations: powers and brackets come before multiplication and division, which come before addition and subtraction. Finally, test the method on the worked example in this guide. If your method reproduces the example answer, the method is right and the inputs deserve a second look.
Quick tips
When a date is ambiguous, such as 04/05/2026, always ask or check the source locale before converting. For spreadsheets, set the cell locale to German so dates parse day-first instead of month-first.