Page 130 - Excel Progamming Weekend Crash Course
P. 130
h540629 ch08.qxd 9/2/03 9:33 AM Page 105
Session 8 — Working with Dates and Times 105
QUIZ YOURSELF
1. How is the date stored in a date value? (See the “The Date Data Type” section.)
2. How would you convert the string representation of a date to a Date data type?
(See the “Date/Time Values” section.)
3. What function reads the date on the system clock? (See the “Date/Time Values”
section.)
4. What function would you use to determine the day of the week that a specific
date falls on? (See the “Date and Time Details” section.)
5. What function gives you maximum control for defining custom date and time
display formats? (See the “Formatting Date/Time Values” section.)
