Thanks Stefi, it works a treat only prob I have is that the name of the sheet
this formula is in has to be the same as a cell next to the x's with a
persons name in it, so when I place J Bloggs in Cell A8 the crosses come into
cells C9 and D9 this has to report to a cell with sheet name J Bloggs, can
you help with this?

Many many thanks

Mark

"Stefi" wrote:

ry this formula:

=IF(Sheet1!C7="x",TEXT(Sheet1!C6,"dd.mmm")&",","") &IF(Sheet1!D7="x",TEXT(Sheet1!D6,"dd.mmm")&",","") &IF(Sheet1!E7="x",TEXT(Sheet1!E6,"dd.mmm")&",","") &IF(Sheet1!F7="x",TEXT(Sheet1!F6,"dd.mmm")&",","") &IF(Sheet1!G7="x",TEXT(Sheet1!G6,"dd.mmm")&",","") &IF(Sheet1!H7="x",TEXT(Sheet1!H6,"dd.mmm")&",","") &IF(Sheet1!I7="x",TEXT(Sheet1!I6,"dd.mmm")&",", "")


--
Regards!
Stefi



€žterilad€� ezt Ã*rta:

Hi,

I need help with a problem.

I have a range of cells C6 to I6 tith the date in them Mon to Sun, below
these cells I have input in some of the cell an X to mark the days a person
is taking a holiday. so Wed, Thurs, Fri the cells below are marked with an X
to indicate a holiday, what I am looking to do is report on another sheet the
dates of the holiday this person is taking, so it would report 10th, 11th and
12th Feb 2010 in cell A1 to indicate the dates of the holiday.

Can anyone help me with this i'm stuck.

Many thanks

Mark