display day

[Guest]

hello everybody

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

best regard

 

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

 

[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

 

[Guest]

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

 

[Guest]

A strand of hair hiding a mountain, thank you.

Colt

"Richard Neville" เขียน:

 

[Guest]

A strand of hair hiding a mountain, thank you.

Colt


"Paul B" เขียน:

 

[Guest]

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

Colt


"Colt" เขียน: