If i input a Date of birth as follows: 01/05/1946

how can i work out in a different cell the following:

# current age
# age at next birthday

Help much appricated

rob


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=538080

Current age

=Today()-<date of birth

e.g A1=01/05/1946 then b1 put =Today()-A1 and format cell as Custom==y

so you should get 60

Age next birthday (01/05/2007)

Current age +1? (61)

HTH

"stapleton2308" wrote:


If i input a Date of birth as follows: 01/05/1946

how can i work out in a different cell the following:

# current age
# age at next birthday

Help much appricated

rob


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=538080