ExcelBanter - Excel 2003 How do I determine an age of "?" using a set date as r

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

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

- - Excel 2003 How do I determine an age of "?" using a set date as r (https://www.excelbanter.com/excel-discussion-misc-queries/226962-excel-2003-how-do-i-determine-age-using-set-date-r.html)

Coach Andrew

Excel 2003 How do I determine an age of "?" using a set date as r

I need to determine the age of a player based their birthdate, then compare
their birthdate to a set cut-off date and determine what age group the player
is to be placed in. I have to work with dates from 1900's and 2000's.
Coach is struggling and we're down by 3. . . . So, I'm calling the bull-pen!

Mike H

Excel 2003 How do I determine an age of "?" using a set date as r

Hi,

=DATEDIF(A1,TODAY(),"y")

Where A1 is the DOB

datedif isn't documented in Excel so for help look here

http://www.cpearson.com/excel/datedif.aspx

Mike

"Coach Andrew" wrote:

I need to determine the age of a player based their birthdate, then compare
their birthdate to a set cut-off date and determine what age group the player
is to be placed in. I have to work with dates from 1900's and 2000's.
Coach is struggling and we're down by 3. . . . So, I'm calling the bull-pen!

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