Help!!!

S

stapleton2308

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
 
T

Toppers

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
 
Top