#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 50
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identifying unique dates in a row of cells containing dates... cdavidson Excel Discussion (Misc queries) 9 October 13th 06 08:43 PM
Identifying unique dates in a range of cells containing dates... cdavidson Excel Discussion (Misc queries) 4 October 13th 06 03:30 PM
Dates and Intervals Dave_Lee Excel Worksheet Functions 8 May 26th 06 01:34 PM
need to convert list of dates to count no. of dates by week neowok Excel Worksheet Functions 13 January 30th 06 04:54 PM
How do I work out people's exact ages from their Dates of Birth? krakowba Excel Discussion (Misc queries) 6 January 20th 06 06:42 PM


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"