ExcelBanter - Birth Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Birth Dates (https://www.excelbanter.com/excel-discussion-misc-queries/123940-birth-dates.html)

Jday

Birth Dates

I would like to calculate the number of years and months of each of my
students from their birth dates. What formula might I use?

Jim Thomlinson

Birth Dates

You probably want the datedif function which is not expained in XL... Give
this link a look...

http://www.cpearson.com/excel/datedif.htm
--
HTH...

Jim Thomlinson

"JDay" wrote:

I would like to calculate the number of years and months of each of my
students from their birth dates. What formula might I use?

All times are GMT +1. The time now is 12:47 PM.