=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","")