| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Define a cell value base on the date
=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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Define a cell value base on the date
Just a thought...
What weekday is this: S Saturday or Sunday? =IF(OR(A1="",A2=""),"",CHOOSE(WEEKDAY(A1&A2),"Su", "M","Tu","W","Th","F","Sa")) Biff "BoniM" wrote in message ... =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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
