Be the first user to complete this post
|
Add to List |
VBA-Excel: Date-Time Functions – Date(), Now() and Time()
Date()
Description:
The Date() function returns a Current system date.
Format:
Date()
Example:
Function FnDate() Dim dtDate dtDate = Date MsgBox "Current System Date is : " & dtDate End Function
_________________________________________________________________________________________________
Now()
Description
The Now function returns the Systems current date and time.
Format:
Now()
Example:
Function FnNow() MsgBox "System's current date and time is " & Now End Function
_________________________________________________________________________________________________
Time()
Description
The Time function returns the Systems current time.
Format:
Time()
Example:
Function FnTime() MsgBox "System's time is " & Time End Function
Also Read:
- VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)
- VBA-Excel: Date-Time Functions – CDate()
- VBA-Excel : Strings Functions – InstrRev
- VBA-Excel: String Functions – strComp()
- VBA-Excel: String Functions – Mid()