DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Month
|
|
|
Day
|
|
|
Year
|
|
|
All of the above
|
Detailed explanation-1: -Example 1: In cell C3, enter the formula =TEXT(B3, "mm/dd/yyyy") and press Enter. The serial number 43466 is instantly converted into date. Note, the resulting date is now in text format. We can also specify a different date format such as in below example.
Detailed explanation-2: -Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.
Detailed explanation-3: -To convert a text date in a cell to a serial number, use the DATEVALUE function. Then copy the formula, select the cells that contain the text dates, and use Paste Special to apply a date format to them.
Detailed explanation-4: -The DT functions convert the result back to a date. There are six DT functions; each one converts a number into a date of a different format.