Description: Adds a certain date
and time interval to a date.
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())
Copyright (C) 1995-2010 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap
