Be the first user to complete this post Login To Mark Completed

0

Add to List Add To List..(Max 5) Close Save

VBA-Excel: Date-Time Functions – DateAdd()

Description:

The DateAdd () function adds the specified time interval to the date and returns a Variant (Date)

Format:

DateAdd(interval,number,date)

Arguments:

• interval
  • Manda­tory
  • Type: String expression
  • The time interval you want to add

Setting	Description
Yyyy	Year
Q	Quarter
M	Month
Y	Day of year
D	Day
W	Weekday
Ww	Week
H	Hour
N	Minute
S	Second

•  number

• Manda­tory
• Type: Numeric
• The number of intervals you want to add
• date
  • Manda­tory
  • Type : Date
  • Date in which the interval will be added

Example:

Function FnDateAdd()

Dim strDate

strDate = CDate("June 24, 2013")    

strNewDate = DateAdd("m", 2, strDate)

MsgBox strNewDate

strNewDate2 = DateAdd("yyyy", -3, strDate)

MsgBox strNewDate2

strDate2 = CDate("June 24, 2013 12:00:00 PM")    

MsgBox DateAdd("h", 2, DateAdd("n", 23, strDate2))

End Function 

---

---

Also Read:

1. VBA-Excel: Delete Blank Rows from Excel Work Sheet
2. VBA-Excel: Arrays – One Dimension, Dynamic Array
3. VBA-Excel: Date-Time Functions – TimeSerial() and TimeValue()
4. VBA-Excel: Date-Time Functions – Date(), Now() and Time()
5. VBA-Excel: Date-Time Functions – Hour(), Minute(), Second()

---