2. 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 1-2.
2. Select cells C5:C9.
3. Enter the following formula: =$B$1-B5.
4. Press <-Ctrl+Enter->
5. From the Format menu, select Cells.
6. Select the Number tab and then select General from the Category list.
7. Click OK.
Note: 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.
Hope You Enjoy This Tutorial - Give Comments
No comments:
Post a Comment