Range function

[Guest]

Dear All

I have a sheet where in 1st row i have dates, eg 10 days to 10 different
clumns

In the rows below i have some values, eg sales. But not in all columns.
Eg in the third column there is a possibility to have sales in only two days
(columns)
in the next column to have sales for 9 days ( columns).

There is any possibilty in one cell to bring the date that i do not have
sales?
EG to make a formula that calculate from the range of the 10 days (Columns)
to check which date i do not have a value and then to bring me the date that
exist in first row.?
For example row 3 i do not have a value in D3. Column D means 10/12/2004
So in Column K, which is the check column for me, to bring me the date
10/12/2004, because D$ do not have a value.

Thanks in advance
Manos

 

[Max]

One way, provided there's only 1 empty cell (no sales figure) per row, in
the sales data in row2 down

Put in K2 and array-enter (press CTRL+SHIFT+ENTER):
=INDEX($A$1:$J$1,MATCH(TRUE,(A2:J2=""),0))

Format K2 as date and copy down