I have dates in column a and number data in the rest of
the column b and c. I will like to create a formula that
will give me the latest date in column a if there are
number data in column b and c. For example if a600 has a
date and c600 has data give me the latest date in column a
600?

Any suggestions?

Thanks!

I think that this is what you're looking for:

=LOOKUP(2,1/((ISNUMBER(B1:B999))*(ISNUMBER(C1:C999))),A1:A999)

Change the 999 to the number of rows you need.

And format the cell with the formula as a date.

Dave wrote:

I have dates in column a and number data in the rest of
the column b and c. I will like to create a formula that
will give me the latest date in column a if there are
number data in column b and c. For example if a600 has a
date and c600 has data give me the latest date in column a
600?

Any suggestions?

Thanks!

--

Dave Peterson