Excel TODAY Function
The Excel TODAY function returns the current date
Example: Excel TODAY Function
=TODAY()
|
Result in cell B5 (26/03/2018) - returns the current date.
|
METHOD 2. Excel TODAY function using the Excel built-in function library
EXCEL
Formulas tab > Function Library group > Date & Time > TODAY
=TODAY() Note: given the Excel TODAY function does not accept arguments there is no option to fill in input boxes. It will return the current date. |
Sub Excel_TODAY_Function()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("TODAY")
'apply the Excel TODAY function
ws.Range("B5") = Date
ws.Range("B5") = Date
End Sub
OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
PREREQUISITES
Worksheet Name: Have a worksheet named TODAY.
Worksheet Name: Have a worksheet named TODAY.
ADJUSTABLE PARAMETERS
Output Range: Select the output range by changing the cell references ("B5") in the VBA code to any cell in the worksheet that doesn't conflict with the formula.
DESCRIPTION
The Excel TODAY function returns the current date.
The Excel TODAY function returns the current date.
SYNTAX
=TODAY()
=TODAY()
ARGUMENTS
The Excel TODAY Function does not accept any arguments.
The Excel TODAY Function does not accept any arguments.
ADDITIONAL NOTES
Note 1: The Excel TODAY Function does not accept any arguments.
Note 2: Each time the worksheet is recalculated or opened the current date will be updated.