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

calculating an age 6
Calculate Age 5
How do I calculate a person's age from date of birth and a date 2
Calculating When Somebody Reaches a Certain Age 4
date formulas 9
date of birth or blank cell? 3
Age 5
Age 3

Top