VBA Datetime Module

Member Description
Calendar Sets the type of calendar. vbCalGreg or vbCalHijri.
Date Returns the current system date as a Variant/Date.
Date$ Returns the current system date as a String.
Now Returns the current system date and time as a Variant/Date.
Time Returns the current system time as a Variant/Date.
Time$ Returns the current system time as a String.
Timer Returns the number of elapsed seconds since midnight as a Single.
DateAdd Returns a date with a given time interval added as a Variant/Date.
DateDiff Returns the quantity of a given time interval between two given dates as a Variant/Long.
DatePart Returns part of a given date as a Variant/Integer. *There is a bug in this function. The last Monday in some years can be returned as week 53 when it should be week 1. See here.
DateSerial Returns a Variant/Date for a given year, month, and day.
DateValue Returns a Variant/Date for a given string representing a date from 1/1/100 through 12/31/9999.
Day Returns the day of the month as a Variant/Integer.
Hour Returns the hour of the day as a Variant/Integer.
Minute Returns the minute of the hour as a Variant/Integer.
Month Returns the month of the year as a Variant/Integer.
Second Returns the second of the minute as a Variant/Integer.
TimeSerial Returns the time for a specific hour, minute, and second as a Variant/Date.
TimeValue Returns the time given a string representing a time from 0:00:00 through 23:59:59 as a Variant/Date.
Weekday Returns a whole number representing the day of the week as a Variant/Integer.
Year Returns a whole number representing the year as a Variant/Integer.