Microsoft Excel Functions & Formulas

Use the DMIN function to find the oldest

person on a team

The oldest member of a team can be found by using the DMIN

function. (To find the youngest person, use DMAX.) Dates are

stored in Excel as integer values beginning with 1 for January 1,

1900, and incrementing by 1 for each subsequent day. For example,

the date 11/16/2004 has the value 38307. The syntax for DMIN is

described in the previous tip.

4

To find the oldest person on a team:

1. Copy to a worksheet cells A1:C10 as shown in Figure 8-8.

2. Copy the range A1:C1.

3. Select cell A12 and press <Ctrl+V>.

4. In cell B13 enter 1 to search just inside team 1.

5. In cell C15 type the following formula: ...