
Index
& operator,
combining columns, 70
combining text and dates, 15
combining text and numbers, 14
combining text and time, 16
100-minute hours, calculating with, 121
360-day year, calculating with, 108-109
A
ADDRESS function, 212-213
determining last used cell, 276-277
finding cell reference for largest
number, 212-213
finding cell reference for smallest
number, 214
summing sales to today’s date, 215
addresses, displaying in and selecting
from drop-down box, 309-310
Advent, calculating weeks of, 118
age,
calculating, 116, 117, 361
calculating in days, 3
determining and shading, 270
determining oldest/youngest, 207
Analysis ToolPak add-in, loading, 107
Analysis T