Excel Functions in EAC ToolsExcel Functions in EAC Tools\Age, date, more functionsAge, date, more functions\DateAdd

DateAdd

DateAdd returns a date which is the result of a number of intervals added to a beginning date.

Syntax

DateAdd (Interval, NumberToAdd, Date1)

Parameter Name

Description

Interval

The type of interval to add to Date1.

Interval

Description

1 or “y”

Year

4 or “q”

Quarter

“m”

Month

“d”

Day

“w”

Week

“h”

Hour

“n”

Minute

“s”

Second

 

NumberToAdd

The number of intervals to add to Date1. A negative number is allowed.

Date1

The beginning date to be added to.