Just to point out the difference, if A2=A1, Fred's would put an X, while
mine would put X Y

You didn't specify what you wanted in this situation (or if that was
something that could happen).

--
Regards,
Tom Ogilvy

Tom Ogilvy wrote in message
...
=Trim(if($A$1=Row(),"X","") & " " & if($A$2=row(),"Y",""))

--
Regards,
Tom Ogilvy

Ed wrote in message
...
Thanks all for your quick replies! All solutions worked out great.

Now, suppose I expand on this. In Cell A2, it indicates the day which
is
an
OFF DAY.

Then, depending on the value of A2, I want to mark a "Y" on one of the
cells
from B1 to B31.

How would I combine the solution from before with this one?

Can I do something like this?
B1: =IF($A$1=ROW(), "X","") or IF($B$1=ROW(), "Y","")