The DATE purpose extracts the calendar year from cell B3, can make an entire day using the month and day figures that you choose to supplied (1-Jan in this example), and passes that date to DATEDIF. As The end result, you can get the patient's age as of January 1 of a specific 12 months:This age calculator is predicated on the best way human age is