The DATE function extracts the 12 months from cell B3, makes a whole date using the thirty day period and day figures that you simply provided (1-Jan in this example), and passes that day to DATEDIF. As the result, you have the patient's age as of January 1 of a specific calendar year:k.a. Pearson age calculator. Estimate the age of an item, such a