> ## Content Index
> Fetch the complete content index at: https://blog.jestor.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How Do You Use the DATEADD Formula to Automatically Set a Due Date Based on the Issue Date?
- URL: https://blog.jestor.com/dateadd-formula-due-date-jestor/
- Published: 2026-07-22T15:51:30.000Z
- Updated: 2026-07-22T15:51:30.000Z
- Author: Bruno Bannach

In **Jestor**, the DATEADD function adds an interval of days, months, or another unit to a base date, letting you automatically calculate the due date from a contract's or bill's issue date.

### Why automate this calculation

Manually setting the due date on every record is repetitive and error-prone, especially when the term is always the same, like 15 days after issuance. The formula removes that manual step.

### How the DATEADD formula works

- You pick the date field that will serve as the base, like "issue date"
- You define the interval to be added, like 15
- You choose the interval's unit: D for days, M for months, among others
- Jestor automatically calculates the new date whenever the base date changes

### How to build the DATEADD formula in Jestor

1. Add a formula-type column with a date return
2. Search for the DATE ADD function inside the formula editor
3. Select the source date field, the interval, and the unit (D, M, etc.)
4. Click create — the due date field is now calculated on its own

### Process automation with always-correct deadlines

Automating the due-date calculation with **process automation** keeps the team from forgetting to fill that field in manually, keeping Jestor's financial deadlines always consistent with company policy.

### Table Summary

| DATEADD parameter | Example from the video |
| ----------------- | ---------------------- |
| **Base date**     | Issue date             |
| **Interval**      | 15                     |
| **Unit**          | D (days)               |

### Video Tutorial: Step by Step

*Video: Ep 18: Formulas in Jestor — video tutorial showing this feature in practice, right inside the Jestor interface.*

## Frequently Asked Questions

**Does the DATEADD formula only work with days?** No, it also accepts months and other time units, depending on how it's configured.

**Does the due date change if I later update the issue date?** Yes, since it's a formula, the result recalculates automatically.

**Do I need to know how to code to use DATEADD?** No, the function is selected right inside the [jestor.com](https://jestor.com/?ref=blog.jestor.com) formula editor, no code needed.

## Get to Know Jestor

With Jestor, you can automate workflows, connect different areas, and build internal systems your way — all without code and with AI support. Check out Jestor at [jestor.com](https://jestor.com/?ref=blog.jestor.com) and discover how to take your company's management to a new level of efficiency and integration.