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.

Try this:

Select the cell(s) that are impacted
Format>Cells>Number tab
Category: Custom

Type: ddd
Returns: Mon, Tue, etc

Type: dddd
Returns: Monday, Tuesday, etc

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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.

Hi Captn'

Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005


HTH
Regards,
Howard

"Captain" <[email protected]> wrote in message
news:[email protected]...
> 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.

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.


select Format, Cells, (Number) ,Custom and type ddd in the Type box.


--
Sumuwin

"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?

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?

"L. Howard Kittle" wrote:

> Hi Captn'
>
> Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005
>
>
> HTH
> Regards,
> Howard
>
> "Captain" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
> How do I get a cell to show the Week Number for specific dates?
Thanks again
Captain

Unless the Captain is English, then it would return TUE

<bg>

--
Regards,

Peo Sjoblom

(No private emails please)


"L. Howard Kittle" <[email protected]> wrote in message
news:[email protected]...
> Hi Captn'
>
> Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005
>
>
> HTH
> Regards,
> Howard
>
> "Captain" <[email protected]> wrote in message
> news:[email protected]...
>> 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.
>
>

"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?

"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:
> Thanks! Great web site!
Captain
> >
> >
> > "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?