The DATE function extracts the 12 months from cell B3, tends to make a whole day using the month and day numbers that you choose to equipped (one-Jan in this instance), and passes that date to DATEDIF. As The end result, you obtain the individual's age as of January 1 of a certain calendar year:The calculator works by using the next formulation to