Calculate the age of a person in days

A worksheet lists the names of friends in column A and their birth dates in column B. To calculate the number of days each person has been alive, enter the current date in cell B1 and perform the following steps:

To calculate the age of a person in days:

1. In a worksheet, enter your own data or the data shown in figure below.
2. Select cells C5:C9 and then enter the following formula: =$B$1-B5.
3. Press Ctrl+Enter.
4. From the Format menu, select Cells.
5. Select the Number tab and then select General from the Category list and then click OK.

The formula must have an absolute reference to cell B1, which is available by going to the formula bar, highlighting the cell reference, and pressing F4 until the appropriate reference appears.