An Excel question

[Ed]

In Cells A1, I am entering the day of the month.

Depending on the value of A1, I want it to mark an X on one of cells B1 to
B31.

e.g. if A1 is the 20th day of the month, I want it to automatically mark
cell B20 with an X.

How do I do that?

Thanks.

 

[JE McGimpsey]

one way:

B1: =IF($A$1=ROW(), "X","")

Copy down to B31.

 

[Ian Coates]

In cell B1 type

=IF(DAY($A$1)=ROW(B1),"X","")

Copy it to the range B1 to B31.

 

[mern]

Sub markit()
Cells(Day(Cells(1, 1)), 2) = "X"
End Sub

 

[Ed]

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

 

[Frank Kabel]

Hi Ed
try
=IF($A$1=ROW(), "X",IF($B$1=ROW(), "Y",""))

Frank

 

[Tom Ogilvy]

=Trim(if($A$1=Row(),"X","") & " " & if($A$2=row(),"Y",""))

 

[Tom Ogilvy]

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).