TablePop automatically detects date columns and provides date-range filters with operators like =, >=, <=, and between.
How It Works #
Your Excel dates must be real dates, not text. To check or change this:
- Select your date cells
- Press
Ctrl+1to open Format Cells - Choose Date as the category
- Pick any display format you like
TablePop will show the dates exactly as formatted in Excel, and the date filter will appear automatically.
Supported Display Formats #
All date formats where day, month, and year are shown as numbers are supported — regardless of order, separator, language, or year length:
| Excel Format | Displayed As | Filter |
|---|---|---|
| DD.MM.YYYY | 17.03.2024 | ✓ |
| DD/MM/YY | 17/03/24 | ✓ |
| MM/DD/YYYY | 03/17/2024 | ✓ |
| YYYY-MM-DD | 2024-03-17 | ✓ |
| YY-MM-DD | 24-03-17 | ✓ |
| DD-MM-YYYY | 17-03-2024 | ✓ |
| DDD DD.MM.YYYY | Fr. 17.03.2024 | ✓ |
| DDDD, DD/MM/YYYY | Freitag, 17/03/2024 | ✓ |
| DDD DD-MM-YY | Fri 17-03-24 | ✓ |
| DDD, MM/DD/YYYY | Fri, 03/17/2024 | ✓ |
| YYYY年MM月DD日 | 2024年03月17日 | ✓ |
| YY年MM月DD日 | 24年03月17日 | ✓ |
Formats with English month names also work, since the browser can parse them:
| Excel Format | Displayed As | Filter |
|---|---|---|
| DD. MMMM YYYY | 15. January 2024 | ✓ |
| DD-MMM-YYYY | 15-Jan-2024 | ✓ |
| MMM DD, YYYY | Mar 17, 2024 | ✓ |
Rule of thumb: as long as the day, month, and year are shown as numbers, the filter always works. English month names also work. Any other separator (weekday names, CJK characters, punctuation) is fine.
Known Limitations #
The following formats are not supported for date filtering:
| Format | Examples | Why |
|---|---|---|
| Non-English month names | 17. März 2024 (DE) 17 mars 2024 (FR) 17 marzo 2024 (ES) 17 marzo 2024 (IT) |
Only English month names can be parsed by the browser |
| Incomplete dates | Jan 24 / Mär 24 / mars 24 March 2024 / März 2024 |
Missing day component — date cannot be determined |
If date filtering doesn't work as expected, switch to a numeric date format in Excel (Ctrl+1 → Date) and regenerate your table.
