DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
TODAY
|
|
|
YEAR
|
|
|
HOUR
|
|
|
DATE
|
Detailed explanation-1: -The method to use this function is as follows =TODAY(). For example, suppose TODAY() returns the current date, e.g., 10-10-2020. Then, to add 7 days to today’s date, we can use the formula =TODAY()+7, which returns the result as 17-10-2020.
Detailed explanation-2: -The TODAY Function[1] is categorized under Excel Date and Time functions. It will calculate and give the current date. It is updated continuously whenever a worksheet is changed or opened by a user. The function’s purpose is to get today’s date.
Detailed explanation-3: -The TODAY function returns the current date, and will continually update each time the worksheet is updated. Use F9 to force the worksheet to recalculate and update the value. The value returned by the TODAY function is a standard Excel date. To display the result as a date, apply a date number format.