View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BaseballFan BaseballFan is offline
external usenet poster
 
Posts: 8
Default Define a cell value base on the date

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