If statements

[cassandra]

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

 

[Trevor Shuttleworth]

Cassandra

=IF(D4="","",
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))
)

Regards

Trevor

 

[Sandy Mann]

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[cassandra]

Thanks for the help. I know there was a way to do it right

 

[Trevor Shuttleworth]

You're welcome. There's often a variety of ways to "do it right" as in this
case ... it's just finding them ;-)