Visual Basic Date and Time Function : DateAdd

Purpose : The DateAdd function returns a variant (date data ) containing a date to which a specified time interval has been added.

Syntax :
DateAdd ( interval, number, date )

interval : The interval of time you want to add that is string expression ( see in blog )
number : the number of intervals you want to add. also use positive and negative value
date : Date to which the interval is added

The interval argument has these setting

Setting Description

yyyy year

q Quarter

m Month

y Day of year

d day

w weekday

h hour

n Minute

s Secound

DateAdd ("m", 1, " 31-Jan-2010")

Return value is 28-Feb-2010