10/14/2015

How To Calculate Age in Days From Date of Birth - Microsoft Excel 2016 F...

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.