I have a worksheet in which I want to write a formula that will look in a
column of 5 rows and return to me the first date that is posted in that
column.

My column of cells consist of Cells C12, C13, C14, C15, and C16. This
column is a date column.

I want to write a formula in Cell A3 that tells Excel to look in C12 and
return the date in C12 to A3, if one exists there. If it does not, then I
want it to look on down to C13 and return that date, but if there is no date
there, then look in C14 and return that one, etc. all the way down to C16
(which will ALWAYS contain a date).

Basically, I want Excel to look in my range of C12:C16 and return to me the
very first cell that is not blank

Is there anyway to do this? I've tried several different formulas (even
using VLOOKUP) and I'm not having any luck.

Thanks,

--
Sherry