Skip to content

Date & Time

DateAdd

Adds a number of units such as days, months or hours to a date/time value.

Syntax

DateAdd(DateTime, Addition [, Units])

Parameters

DateTime: The starting date/time.
Addition: How many units to add. Use a negative number to subtract.
Unitsoptional: A TimeUnit value such as TimeUnit.Hours. Days if omitted.

Examples

```
=DateAdd(Today(), 7)
```
One week from today
```
=DateAdd(Now(), -2, TimeUnit.Hours)
```
Two hours ago

Official documentation on Microsoft Learn