Trevor gave you the answer for your formula but you could also use the
DATEDIF function:

=If (D1="","",DATEDIF(D1,TODAY(),"y"))

The DATEDIF function is only explained in XL 2000 Help but Chip Pearson has
a page on his Website about it:

http://www.cpearson.com/excel/datedif.htm

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"cassandra" wrote
in message ...

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