Age Help

[Michael Cadle]

Everone one is so very helpful here.

I have another issue I need help with.

cell A1 contains their birthday. I want cell A2 to contain their age as of today.

If A1 is blank then I want A2 to remain blank. Thus there is no age calucation until a birthday is entered into A1.

The age can be simple just the year.

Again thanks everyone for your help. This is a great place.

 

[mhenk]

Probably way too complicated, but this is the first one of mine that I came across:

=YEAR($D$8)-YEAR($D$18)-IF(MONTH($D$8)<MONTH($D$18),1,0)-IF(AND(MONTH($D$8)=MONTH($D$18),DAY($D$8)<DAY($D$18)),1,0)

D8 is the birthday, D18 is the evaluation day, can be changed to now(), probably.

Strap an if statement on there and you're good to go

 

[facethegod]

Try this.... age is based on 30 day months w/ a 360 day year

=IF(A1="","",(YEAR(TODAY())-YEAR(A1))+IF(DAY(TODAY())<DAY(A1),MONTH(TODAY())-1-MONTH(A1),MONTH(TODAY())-MONTH(A1))/12+IF(DAY(TODAY())<DAY(A1),30+DAY(TODAY())-DAY(A1),DAY(TODAY())-DAY(A1))/360)

 

[Michael Cadle]

The age calucation is the easy part

=DATEDIF(L14,NOW(),"y")

What I dont know how to acomplish is if cell L14 is empty I do not want a date in cell M14.

Anyt thoughts

 

[Joe Was]

=If(L14="","",DATEDIF(L14,NOW(),"y"))

 

[VoG]

Try

=IF(ISBLANK(L14),"",DATEDIF(L14,NOW(),"y"))

 

[Traveler]

The age can be simple just the year.

=IF(A1="","",YEAR(TODAY())-YEAR(A1))

make sure you format the cell as General. Excel tries to be helpful and changes the format to Date when it sees such things as dates in the formula.

 

[brian.wethington]

The age can be simple just the year.

=IF(A1="","",YEAR(TODAY())-YEAR(A1))

make sure you format the cell as General. Excel tries to be helpful and changes the format to Date when it sees such things as dates in the formula.

what about if they have not had their birthday yet this year?

As for your other part, the datedif functions work fine to get the age... this will get your if portion taken care of

=if(A1, FunctionHere, "")