DateAdd Function

Adds a date interval to a given date a number of times and returns the resulting date.

Notkun:


DateAdd (Add, Count, Date)

Skilagildi:

A Variant containing a date.

Viðföng:

Add - A string expression from the following table, specifying the date interval.

Add (string value)

Útskýring

yyyy

Ár

q

Ársfjórðungur

m

Mánuður

y

Dagur ársins

w

Vikudagur

ww

Vika í ári

d

Dagur

h

Klukkustund

n

Mínúta

s

Sekúnda


Count - A numerical expression specifying how often the Add interval will be added (Count is positive) or subtracted (Count is negative).

Date - A given date or the name of a Variant variable containing a date. The Add value will be added Count times to this value.

Dæmi:


Sub example_dateadd
    MsgBox DateAdd("m", 1, "1/31/2004") &" - "& DateAdd("m", 1, "1/31/2005")
End Sub

Please support us!