CONVERT A DATE TO A DAY
 

I would like to know the formula to convert a date, such as *Wednesday,
1-Oct-08 to read "Wednesday", that is, plain old text which says "Wednesday".
Please advise.

DOUG

CONVERT A DATE TO A DAY
 

If cell A1 contains a true Excel date:

=TEXT(A1,"dddd") returns Wednesday

=TEXT(A1,"ddd") returns Wed

--
Biff
Microsoft Excel MVP


"DOUG ECKERT" wrote in message
...
I would like to know the formula to convert a date, such as *Wednesday,
1-Oct-08 to read "Wednesday", that is, plain old text which says
"Wednesday".
Please advise.

DOUG

CONVERT A DATE TO A DAY
 

Or you can format the date number in the format menu. Choose Format, Cells,
Custom and enter three or four d.

This way it retains the date properties and you can perform operations on it
in the normal way.

Regards

Peter Atherton

"T. Valko" wrote:

If cell A1 contains a true Excel date:

=TEXT(A1,"dddd") returns Wednesday

=TEXT(A1,"ddd") returns Wed

--
Biff
Microsoft Excel MVP


"DOUG ECKERT" wrote in message
...
I would like to know the formula to convert a date, such as *Wednesday,
1-Oct-08 to read "Wednesday", that is, plain old text which says
"Wednesday".
Please advise.

DOUG

CONVERT A DATE TO A DAY
 

I think they wanted a text result:

"Wednesday", that is, plain old text which says "Wednesday".

Either way, now they have both options.

--
Biff
Microsoft Excel MVP


"Billy Liddel" wrote in message
...
Or you can format the date number in the format menu. Choose Format,
Cells,
Custom and enter three or four d.

This way it retains the date properties and you can perform operations on
it
in the normal way.

Regards

Peter Atherton

"T. Valko" wrote:

If cell A1 contains a true Excel date:

=TEXT(A1,"dddd") returns Wednesday

=TEXT(A1,"ddd") returns Wed

--
Biff
Microsoft Excel MVP


"DOUG ECKERT" wrote in message
...
I would like to know the formula to convert a date, such as *Wednesday,
1-Oct-08 to read "Wednesday", that is, plain old text which says
"Wednesday".
Please advise.

DOUG