Look at Day of Week to populate Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
pkley said:
Ok, I have my date cell displaying the date as mm/dd/yy - dddd. I
Click to expand...
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
Click to expand...
what day of the week it is based on the date in the Date cell. Any
suggestions?
 
Back
Top