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