In this Microsoft Excel Tutorial, we are going to
calculate the age of a person in days. Here, we have a worksheet in which,
Column A represents the name of the family members, and Column B have their
date of birth respectively. In Colum C, what I need to calculate is the number
of days; each person has been alive, according to the today’s date entered in
cell B1.
To calculate the age of a person
in days, first select the cells from C4 to C7, and then enter the following
formula.
=,$B,$1,-,B4.
And then hold down the control
key and press Enter. This way the formula will automatically be copied to the
selected cells. We are using the absolute reference for the Cell B1, because we
need to subtract each person’s date of birth from today’s date entered in Cell
B1. So, when I will copy the formula, the today’s date reference in each cell
will remain the same, whereas birthday cell reference will change automatically
because of relative reference has been used.
One more thing I would like to add in this formula is to,
add “days” in the end of each result. To get this, you need to change the
formula a little bit. Just add, ampersand in the end, followed by Days inside
inverted commas.
Comments
Post a Comment