xv
Table of Contents
Converting a Date from Text ...................................................................... 243
Finding Out What TODAY Is .......................................................................245
Counting the days until your birthday ............................................246
Counting your age, in days ...............................................................246
Determining the Day of the Week ..............................................................246
Working with Workdays .............................................................................248
Determining workdays in a range of dates ..................................... 248
Workdays in the future .....................................................................250
Calculating Time between Two Dates with the DATEDIF Function ......251
Chapter 13: Keeping Well-Timed Functions .....................255
Understanding How Excel Handles Time .................................................255
Formatting Time ..........................................................................................256
Keeping TIME ...............................................................................................258
Text to Time with TIMEVALUE ..................................................................258
Deconstructing Time with HOUR, MINUTE, and SECOND ......................259
Isolating the hour ...............................................................................260
Isolating the minute ...........................................................................261
Isolating the second ..........................................................................262
Finding the Time NOW ................................................................................262
Calculating Elapsed Time over Days .........................................................263
Chapter 14: Using Lookup, Logical, and Reference Functions......265
Testing on One Condition ...........................................................................266
Choosing the Right Value ...........................................................................271
Let’s Be Logical ............................................................................................ 273
NOT ......................................................................................................273
AND and OR ........................................................................................ 274
XOR ...................................................................................................... 277
Finding Where It Is .......................................................................................278
ADDRESS .............................................................................................278
ROW, ROWS, COLUMN, and COLUMNS ..........................................282
OFFSET ................................................................................................284
Looking It Up ................................................................................................ 286
HLOOKUP and VLOOKUP .................................................................286
MATCH and INDEX .............................................................................290
FORMULATEXT ..................................................................................294
NUMBERVALUE ..................................................................................295
Chapter 15: Digging Up the Facts ..............................297
Getting Informed with the CELL Function ................................................ 297
Getting Information about Excel and Your Computer System ..............303
Finding What IS and What IS Not ............................................................... 304
ISERR, ISERROR, and ISNA ................................................................ 305
ISBLANK, ISNONTEXT, ISTEXT, and ISNUMBER ............................306
Getting to Know Your Type ........................................................................308