CONVERT A DATE TO A DAY

  • Thread starter Thread starter DOUG ECKERT
  • Start date Start date
D

DOUG ECKERT

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
 
If cell A1 contains a true Excel date:

=TEXT(A1,"dddd") returns Wednesday

=TEXT(A1,"ddd") returns Wed
 
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
 
Back
Top