Look at Day of Week to populate Cell

[Guest]

Ok, I have my date cell displaying the date as mm/dd/yy - dddd. I have another cluster of cells like thi
[] [] [] [] [] [] [
M T W ThF S S
In the cell above each day of the week, I want to put an X based on what day of the week it is based on the date in the Date cell. Any suggestions?

 

[Norman Harker]

Hi pkley!

For Monday with the date in B1

=IF(WEEKDAY($B$1,2)=1,"X","")

Increment day by 1 for Tuesday etc.

The second argument for the WEEKDAY function is the basis for Monday =
1, Tuesday = 2 etc

If you have a large number of these it should be possible to make the
formula more efficient.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Ok, I have my date cell displaying the date as mm/dd/yy - dddd. I

have another cluster of cells like this

[] [] [] [] [] [] []
M T W ThF S SU
In the cell above each day of the week, I want to put an X based on

what day of the week it is based on the date in the Date cell. Any
suggestions?