=CHOOSE(WEEKDAY(DATEVALUE(A1&" "&A2)),"S","M","T","W","T","F","S")

"BaseballFan" wrote:

I'd like to define the value of a cell to be the first letter of the day of
the week, based on the current year, when I supply the Month and Day from
other cells.

Example:
A1 = "April"
A2 = 1

Since April 1st of this year was a Sunday, the value of my cell, A3, would
be "S"

If I changed A2 to the number 10, then A3 would change to "T" because the
10th of April of this year is a "T"uesday.

I appreciate any help anyone can provide on this.

Jimmy