Day of Week

  • Thread starter Thread starter Peter Carlson
  • Start date Start date
P

Peter Carlson

I have a grid that shows:

Jan 2006
1 M
2 T
3 W
4 T
....
31

I would like for the 2nd column which is the first letter of the Weekday
Name to be auto calculated from the combination of $MONTH, $YEAR and the
corresponding cell in Column $A.

I'm stumped
Peter
 
I have a grid that shows:

Jan 2006
1 M
2 T
3 W
4 T
...
31

I would like for the 2nd column which is the first letter of the Weekday
Name to be auto calculated from the combination of $MONTH, $YEAR and the
corresponding cell in Column $A.

I'm stumped
Peter
Click to expand...

Assuming your Month name is text in A1; and year is in B1:

=LEFT(TEXT(DATEVALUE($A2&$A$1&$B$1),"ddd"),1)


--ron
 
Assuming "Jan" is in A1, 2006 in B1 you could use, in B2

=LEFT(TEXT(A2&"-"&A$1&"-"&B$1,"ddd"))

copy down column
 
Back
Top