# How to calculate a Date plus/minus X days

Topic Labels: Formulas
Solved
690 2
cancel
Showing results for
Did you mean:
6 - Interface Innovator

Hello,

I am looking for a way to calculate a date minus x days based on a date field. I.e. the result should be 31.12.2023 (DD.MM.YYYY) minus 10 days = 21.12.2023.

How can I do this?

I tried to use this formula, but it returned an error:

``DATETIME_FORMAT(DATEADD({Date Field}, -10, 'days'), 'DD.MM.YYYY')``

Thanks for help,
M.

1 Solution

Accepted Solutions
6 - Interface Innovator

Sorry, had a typo in the formula. It does work 🙂

So this is working:

``DATETIME_FORMAT(DATEADD({Date Field}, -10, 'days'), 'DD.MM.YYYY')``
2 Replies 2
6 - Interface Innovator

Sorry, had a typo in the formula. It does work 🙂

So this is working:

``DATETIME_FORMAT(DATEADD({Date Field}, -10, 'days'), 'DD.MM.YYYY')``
6 - Interface Innovator

Hi @micha281sth , I'm trying to do this too, but with a couple tweaks. I'd like to show a date field that is 3 workdays later (+3 workdays) from the reference date field.

I get an error when trying to do +3, and if I just use "3", it either adds zero or just one day... I'm confused!

This is my formula:

`DATETIME_FORMAT(DATEADD(Created, 3, 'workdays'), 'MM/DD/YY')`