Date and Time Related Functions

VBA has a large number of functions related to manipulating dates and times. Table 8-2 contains a selection.

Table 8-2. Some Date- and Time-Related Functions



Date, Now, Time

Get the current date or time.

DateAdd, DateDiff, DatePart

Perform date calculations.

DateSerial, DateValue

Return a date.

TimeSerial, TimeValue

Return a time.

Date, Time

Set the date or time.


Time a process.

0 0

Post a comment