Hi,

I have a couple of data files that have 2 date of birth fields. Some cells
in each are blank. What I need to do is replace DOB with insureeDOB if DOB is
empty and InsureeDOB is populated. As there are several thousand records in
each file I don't want to have to do this manually. Is there a formula that
can do this? I am using Excel 2000.

Many thanks.
Chris