See this page Gary

For VBA
http://www.cpearson.com/excel/DateTimeVBA.htm

Function
http://www.cpearson.com/excel/DateTimeWS.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Gary" wrote in message ...
I need a Formula that will figure the difference between two dates'

If a child is 8 on 12/2/2002 then he will be 9 on 12/2/2003, but on
12/1/2003 hw will still be 8

how do I set up a caluclation to figure this for me