Formula falling over in more than one cell

[moviegrrl]

Hi, hope you can help me.
I'm trying to import information from one worksheet into a calendar -
if the date value fits, then info from cells on the same line should be
imported to the calendar page.

This formula
=IF(Sheet1!B:B=DATE(2006,5,30), CONCATENATE(Sheet1!D," ",
Sheet1!E:E," ", Sheet1!H:H," ", Sheet1!I:I, " ")," ")

works brilliantly, but only as that one function, if I change the date
to a previous or later one, I don't get a return value.
The formula isn't coming up with an error, but there's obviously
something going on that Excel doesn't like.

Any ideas?

 

[Bob Phillips]

Are you sure that the other date actually exists within the data?

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

 

[moviegrrl]

Absolutely!
For each month I have a set of specific dates - they are all listed o
the Sheet that I'm trying to work with, they are all in correct dat
formula and all I'm doing is copying the formula and changing the dat
but with no luck.

 

[Dave Peterson]

Any chance that some of your dates may be text that looks like a date?

I'd one of the cells that looks like it should work (but doesn't) as a date.
Then reenter that date.

==
Any chance your dates include time?

 

[moviegrrl]

Nope, the dates are definately dates, and don't include time.

What is particularly weird is that it is only the one date (30th May)
that works, any other date doesn't. But they are all entered in the
same fashion and the formula in each cell is identical but for the date
change.
Frustrating isn't the word for it!

 

[Bob Phillips]

Send me your workbook.

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)