Be the first user to complete this post

  • 0
 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
Date()
Date()

_________________________________________________________________________________________________
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
Now()
Now()

_________________________________________________________________________________________________
Time()

Description

The Time function returns the Systems current time.

Format:

Time()

Example:

Function FnTime()

    MsgBox "System's time is " & Time    

End Function
Time()
Time()

Also Read:

  1. VBA-Excel: Arrays – Two Dimensional, Static Array
  2. VBA-Excel: Date-Time Functions – Day()
  3. VBA Excel - Cells, Ranges and Offset: Refer to Cells by Using Shortcut Notation
  4. VBA-Excel: Cells Ranges Offset - Active Cell
  5. VBA-Excel: Date-Time Functions – Hour(), Minute(), Second()