The date data cleaner
toolbox.
Translate date formats, decode serials and compare explicit time intervals.
10 useful places to start.
Input conventions and time offsets are explicit. No ambiguous day/month order or geographic daylight-saving rule is guessed.
Date format converter
Translate explicitly ordered numeric dates into unambiguous formats.
Excel date serial converter
Translate date-times and spreadsheet serials while exposing the 1900 leap-day anomaly.
ISO week date to calendar date
Turn a week-year, ISO week and weekday into a Gregorian calendar date.
ISO day-time duration converter
Convert a fixed ISO-style day/time duration to seconds and back.
Elapsed time between dated instants
Compare two ISO date-times with explicit UTC offsets.
Shift a list of dates
Move dates by days or calendar months while preserving their input order.
Merge clock-time intervals
Calculate distinct occupied time from overlapping same-day intervals.
12-hour & 24-hour time converter
Translate explicitly written AM/PM times and 24-hour clock times.
Extract CSV date parts
Add calendar fields from a strict ISO date column.
Unix timestamp converter
Convert Unix seconds or milliseconds to a UTC date and back.
A few things you
can tick off.
- Check a spreadsheet date system
- Resolve numeric dates with a stated order
- Measure elapsed time across supplied offsets