View Single Post
  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

Alex

Use the undocumented(except for xl2000)DATEDIF Function.

See Chip Pearson's site for details.

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


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 04:17:02 -0800, AlexS.
wrote:

i need to work out somebody's age from their birthday at different points in
time. Please help if you have an existing formula/speadsheet