25/11/2018
Calculate the age of a person in days!!
A lists the names of in column A and their dates in column B. To calculate the number of days each person has been , enter the current date in cell B1 and perform the following steps:
*To calculate the age of a person in days:
the example http://bit.ly/2P1nRgj
1. In a worksheet, enter your own data or the data shown in PIC.
2. Select cells C5:C9.
3. Enter the following formula: =$B$1-B5.
4. Press .
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.