Posted to microsoft.public.excel.misc
|
|
How do I get a cell to show the day of the week when date ente
"Ron Coderre" wrote:
You'd think that was an easy question, right?
Check Chip Pearson's website for the range of answers....
http://www.cpearson.com/excel/weeknum.htm
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"Captain" wrote:
"Captain" wrote:
How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.
Thanks! Is there a way to get the week # for a specific date?
|