> For the complete documentation index, see [llms.txt](https://docs.tabula.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tabula.io/data-transformation/formulas/date-and-time-functions/dateadd.md).

# DateAdd

Adds the specified value for the specified date or time part to date \ time \ datetime

```mathematica
DateAdd("2021-01-04", 2, DateValueOption.MONTH) → 2021-03-04
DateAdd(column1, 7, DateValueOption.DAY) → 2023-02-06

```

#### Inputs

`DateAdd(dateTime, value, datePart)`

* `dateTime` - Date, time, or datetime value
* `value` - This is the number of units of time that you want to add
* `datePart` - This indicates the units of time that you want to add, ex. DateValueOption.DAY