display day

hello everybody

I have question,
What function that convert date - dd/mm/yy - to display day - Sunday,
Monday, Tuesday, We............ -.

best regard

Select the cell(s) you want to display with the name of the day. Go to
Format-Cells and click the Number tab and the Custom category. In the box
under "Type" enter dddd. No conversion required--you are simply changing the
date format.

"Colt" <Colt@discussions.microsoft.com> wrote in message
news:557A3B21-F990-4004-96F5-8CDCEBCB7AE9@microsoft.com...
> hello everybody
>
> I have question,
> What function that convert date - dd/mm/yy - to display day - Sunday,
> Monday, Tuesday, We............ -.
>
> best regard

Colt, format the cell as custom dddd
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Colt" <Colt@discussions.microsoft.com> wrote in message
news:557A3B21-F990-4004-96F5-8CDCEBCB7AE9@microsoft.com...
> hello everybody
>
> I have question,
> What function that convert date - dd/mm/yy - to display day - Sunday,
> Monday, Tuesday, We............ -.
>
> best regard

hi
=text(7/25/05,"ddd") = Fri
=Text(7/25/05,"dddd") = Friday
if you have the above date in cell A1and want to know what day it is...
=text(A1,"ddd") = Fri

regards

FSt1

"Colt" wrote:

> hello everybody
>
> I have question,
> What function that convert date - dd/mm/yy - to display day - Sunday,
> Monday, Tuesday, We............ -.
>
> best regard

A strand of hair hiding a mountain, thank you.

Colt

"Richard Neville" เขียน:

> Select the cell(s) you want to display with the name of the day. Go to
> Format-Cells and click the Number tab and the Custom category. In the box
> under "Type" enter dddd. No conversion required--you are simply changing the
> date format.
>
> "Colt" <Colt@discussions.microsoft.com> wrote in message
> news:557A3B21-F990-4004-96F5-8CDCEBCB7AE9@microsoft.com...
> > hello everybody
> >
> > I have question,
> > What function that convert date - dd/mm/yy - to display day - Sunday,
> > Monday, Tuesday, We............ -.
> >
> > best regard
>
>
>

A strand of hair hiding a mountain, thank you.

Colt


"Paul B" เขียน:

> Colt, format the cell as custom dddd
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Colt" <Colt@discussions.microsoft.com> wrote in message
> news:557A3B21-F990-4004-96F5-8CDCEBCB7AE9@microsoft.com...
> > hello everybody
> >
> > I have question,
> > What function that convert date - dd/mm/yy - to display day - Sunday,
> > Monday, Tuesday, We............ -.
> >
> > best regard
>
>
>

A strand of hair hiding a mountain, thank you for any help.

Colt


"Colt" เขียน:

> hello everybody
>
> I have question,
> What function that convert date - dd/mm/yy - to display day - Sunday,
> Monday, Tuesday, We............ -.
>
> best regard