# 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: 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:

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

The question should be specific, self-contained, and written in natural language.
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.