Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Date & Time functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - DateAdd function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Date and Time - DateAdd

Syntax:
=DateAdd(Interval, Number, ADate)

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())

litLIB