| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you convert an uncoded date (e.g., 20080304) to a date form | Excel Worksheet Functions | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
| how to convert julian date to regular calendar date | Excel Worksheet Functions | |||
| Convert date to length of time in months from set date | Excel Worksheet Functions | |||
![DOUG ECKERT[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
