Try this:

=IF(COUNT(C2:Z2),LOOKUP(10^10,C2:Z2,$C$1:$Z$1),"")
copy down


"CHerzog" wrote:

I have a work sheet with more then seven columns, each column has a cell with
a title in it. I want to know if it is possable to have a column with a
function or formula that will insert the column title if a date is entered in
that column.
I am using Excel 2003. See below for a picture of what I am looking for.

DCN1 DCN2 DCN3

Page 1 DCN1 01/02/06
Page 2 DCN3 01/02/06 05/03/07 08/09/07
Page 3 DCN2 01/02/06 05/03/07