Posted to microsoft.public.excel.misc

Captain

Posts: n/a

How do I get a cell to show the day of the week when date entered

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
user defined function	Brian Rogge	Excel Worksheet Functions	5	May 23rd 05 06:21 PM
enter a time into a cell, have the cell show two times the entry	johnp	Excel Worksheet Functions	3	May 2nd 05 12:08 AM
Changing Cell formats to date fields automatically	PCLIVE	Excel Worksheet Functions	3	April 12th 05 10:34 PM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
Using formulas to determine date in one cell based on date in anot	Gary	Excel Worksheet Functions	2	November 22nd 04 08:11 AM

All times are GMT +1. The time now is 07:19 AM.

About Us

"It's about Microsoft Excel"