Date
Date Math
Adds or subtracts days, weeks, months, years or smaller units to a date — a fixed amount or a number from another column — and can round the result down to the start of a period.
When to use it
Use it for due dates (order date + 30 days), renewal dates (start + 12 months), or to snap dates to the start of their month or week for reporting.
In a pipeline
File InputDate MathExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| Operation | select | — | add |
| Amount | number | — | 0 |
| Amount from column (per row) | select | — | None: use the Amount above |
| Unit | select | — | days |
| Then round down to | select | — | none |
| From Format | select | — | AUTO |
| To Format | select | — | YYYY-MM-DD |
| Generate New Column | checkbox | — | true |
| New Column Name | text | — | Default: <column> Result |
| Insert After | select | — | After the date column |
Example
Due 30 days after ordering
- Column=OrderDate
- Operation=Add
- Amount=30
- Unit=Days
- New Column Name=Due
| Order | OrderDate |
|---|---|
| A-1 | 2026-10-15 |
| A-2 | 2026-01-31 |
| Order | OrderDate | Due |
|---|---|---|
| A-1 | 2026-10-15 | 2026-11-14 |
| A-2 | 2026-01-31 | 2026-03-02 |
Worth knowing
- Adding months keeps the day where it can and otherwise uses the month's last day: 31 January + 1 month is 28 February, as Excel's EDATE does.
- Pick Amount from column to use a different number on each row; rows with no number there get a blank result.
- Round down without moving the date by leaving Amount at 0 and choosing Start of month (or week, quarter, year).
- Set To Format to a date-and-time format when the time of day matters.