> For the complete documentation index, see [llms.txt](https://docs.infotopics.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.infotopics.com/supertables/guides/setting-up-calculations/date-calculation.md).

# Date Calculation

Date calculations are added in SuperTables 5.4.0. They allow you to do powerful calculations based on date fields and number fields. You can calculate with either dates and/or numbers combined.

Examples:

```
DATE(Order Date) - DATE(Delivery Date)
```

Or when using a number:

```
DATE(Order Date) + (SUM(Nr of Shipping Days) * DAY())
```

Numbers are by default in seconds. Therefore we added multiple helpers:![](/files/uXNTaonl3nNAuqhFmEKt)

#### Step 1: Open Configuration 

{% tabs %}
{% tab title="Dashboard extension" %}
Click on the container that has SuperTables running. This will display an arrow that you can click to open a menu. Upon opening the menu, click the 'Configure...' option to open the configuration panel for SuperTables.

<figure><img src="/files/5Av1IhcpSaex5vwah2hM" alt=""><figcaption><p>Opening configuration panel in Dashboard </p></figcaption></figure>
{% endtab %}

{% tab title="Viz extension" %}
To open the configuration panel, simply click 'Format extension' in the Marks pane.

<figure><img src="/files/xwZgjTFwnF4RM4iU6ghd" alt="" width="247"><figcaption><p>Opening the configuration panel in Viz extensions</p></figcaption></figure>
{% endtab %}
{% endtabs %}

#### Step 2: Navigate to the Data tab

<figure><img src="/files/1EvRpcogDoNCNDt0NOqS" alt=""><figcaption></figcaption></figure>

#### Step 3: Make a Calculation Column

On the left side of the data tab. There is pane that says calculations, expand that menu and click 'Make a calculation' to create one.

<figure><img src="/files/vBL03d6XRD80LxAsAabF" alt=""><figcaption></figcaption></figure>

#### Step 4: Navigate to the Calculation Box

Navigate to the box that contains Calculation and set the Column Display type to 'Date'

<figure><img src="/files/gCkVjM4Dv5FI6drXN8EZ" alt="" width="563"><figcaption></figcaption></figure>

#### Step 5: Write a calculation like this

{% hint style="success" %}
You can also use InputTables columns to calculate with date fields. For a dynamic updating dates.
{% endhint %}

<figure><img src="/files/epH9pFuXnJgFbG4QeRUh" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.infotopics.com/supertables/guides/setting-up-calculations/date-calculation.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.