Interval :

yyyy	year	q	quarter
m	month	d	day
ww	week	w	weekday
y	day of year	h	hour
n	minute	s	second

Number : Number of intervals to add to the date ADate
ADate : The date and time to add the interval to.

Example:

Add one year to the current date. =DateAdd("yyyy",1,NOW()) Add one quarter to the current date.

=DateAdd("q",1,NOW()) Add one month to the current date.

=DateAdd("m",1,NOW()) Add one day to the current date.

=DateAdd("d",1,NOW())

Add one week to the current date.

=DateAdd("ww",1,NOW())

Add one hour to the current date and time. =DateAdd("h",1,NOW())

Add one minute to the current date and time. =DateAdd("n",1,NOW())

Add one second to the current date and time. =DateAdd("s",1,NOW())