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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top