DateAdd Function

αž”αžΌαž€β€‹αž…αŸ†αž“αž½αž“β€‹αžŠαž„β€‹αž“αŸƒβ€‹αž…αž“αŸ’αž›αŸ„αŸ‡β€‹αž–αŸαž›β€‹αž€αžΆαž›αž”αžšαž·αž…αŸ’αž†αŸαž‘β€‹αž‘αŸ…β€‹αž€αžΆαž›αž”αžšαž·αž…αŸ’αž†αŸαž‘β€‹αžŠαŸ‚αž›β€‹αž”αžΆαž“β€‹αž•αŸ’αžŠαž›αŸ‹ αž αžΎαž™β€‹αžαŸ’αžšαž‘αž”αŸ‹β€‹αž€αžΆαž›αž”αžšαž·αž…αŸ’αž†αŸαž‘β€‹αž›αž‘αŸ’αž’αž•αž›Β αŸ”

αžœαžΆαž€αŸ’αž™β€‹αžŸαž˜αŸ’αž–αž“αŸ’αž’ αŸ–

DateAdd (Add, Count, Date)

αžαž˜αŸ’αž›αŸƒβ€‹αžαŸ’αžšαž‘αž”αŸ‹ αŸ–

αžœαŸ‰αžΆαžšαŸ’αž™αŸ‰αž„αŸ‹β€‹αž˜αž½αž™β€‹αžŠαŸ‚αž›β€‹αž˜αžΆαž“β€‹αž‘αž·αž“αŸ’αž“αž“αŸαž™β€‹αž˜αž½αž™Β αŸ”

αž”αŸ‰αžΆαžšαŸ‰αžΆαž˜αŸ‰αŸ‚αžαŸ’αžš αŸ–

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

Add (αžαž˜αŸ’αž›αŸƒβ€‹αžαŸ’αžŸαŸ‚β€‹αž’αž€αŸ’αžŸαžš)

αžŸαŸαž…αž€αŸ’αžαžΈβ€‹αž–αž“αŸ’αž™αž›αŸ‹

yyyy

αž†αŸ’αž“αžΆαŸ†

q

αž˜αž½αž™β€‹αž—αžΆαž‚β€‹αž”αž½αž“

m

αžαŸ‚

y

αžαŸ’αž„αŸƒβ€‹αž“αŸƒβ€‹αž†αŸ’αž“αžΆαŸ†

w

αžαŸ’αž„αŸƒβ€‹αž’αŸ’αžœαžΎαž€αžΆαžš

ww

αžŸαž”αŸ’αžŠαžΆαž αŸβ€‹αž“αŸƒβ€‹αž†αŸ’αž“αžΆαŸ†

d

αžαŸ’αž„αŸƒ

h

αž˜αŸ‰αŸ„αž„

n

αž“αžΆαž‘αžΈ

s

αžœαž·αž“αžΆαž‘αžΈ


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.

αž§αž‘αžΆαž αžšαžŽαŸ αŸ–

Sub example_dateadd

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

End Sub