I have if statement to get the current age. but if there is DOB is
blank the current age is 105.

DOB is D4 and the if statement is in Current age D5

=IF(MONTH(TODAY())MONTH(D4),YEAR(TODAY())-YEAR(D4),
IF(AND(MONTH(TODAY())=MONTH(D4),DAY(TODAY())=DAY( D4)),
YEAR(TODAY())-YEAR(D4),(YEAR(TODAY())-YEAR(D4))-1))



What if statment should i use to get Current age to be blank until
there is a date entered in the DOB.


Thanks


--
cassandra
------------------------------------------------------------------------
cassandra's Profile: http://www.excelforum.com/member.php...o&userid=27026
View this thread: http://www.excelforum.com/showthread...hreadid=438908