Stuart,

To use worksheet functions, you can only check one row at a time:

=SUBSTITUTE(SUBSTITUTE(ADDRESS(1,MATCH(A$2,B1:AH1, FALSE)+1),"$1",""),"$","")

and then copy down for each row you want to check.

HTH,
Bernie
MS Excel MVP


"Stuart WJG" wrote in message
...
I need a formula that can look for a date in
a cell that matchs a date in a range and then enter column letter in the
formula cell
Formula in A1
Variable cell (date) A2
Range B1:ah6