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.
 |
| CALCULATE THE AGE OF A PERSON IN DAYS - MICROSOFT EXCEL TUTORIALS |
Microsoft Excel Tutorials, Simple Formula, Basic Tutorial, Formulas In Excel, Microsoft Excel Video Tutorials
No comments:
Post a Comment