Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line information pulled out base on date | Excel Discussion (Misc queries) | |||
Define Name in active cell | Excel Worksheet Functions | |||
Warning message base on date | Excel Worksheet Functions | |||
how to define a cell to where i can link to it. | Excel Discussion (Misc queries) | |||
Problem with date base units for x axis | Charts and Charting in Excel |