Excel Help

[SyCD]

Im currently upkeeping a membership database at work and wehave a collumfor date of birth. is it possible, and if so what is the formula to have a collum next to DOB that shows the actual age of the person.

Sy

 

[Black-Clio-1.4]

hmmm.... it's easy... I think. 1 sec.

 

[Galzzly]

=INT((TODAY()-A1)/365.25)

Where A1 has the persons DOB in.

 

[Black-Clio-1.4]

Okay.....

Listen carefully.

Date of Birth ----- [A1]

=int((today()-A2)/365.25

As Above¬!

 

[chris_182]

to be accurate you'd actually want to change that to reflect actual leap year incidence, but hey I'm just in a nit picking mood.

 

[Galzzly]

Could always do:

=INT(YEARFRAC(A1,TODAY()))

Again - with A1 being the DOB