Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert a date into the day name in Excel ?
There are examples in the Help but none works.
I should be able to do =text(A3, "ddd") or =text(A3, "dddd") : I get an error message saying that the formula has error. Obviously there is no indication what the error is. I am using Excel 2003. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert a date into the day name in Excel ?
Your "date" is probably text. You can check with the ISNUMBER or ISTEXT
function. Format the cell as date or number and re-enter the date. Just formatting won't do; you need to re-enter. -- Kind regards, Niek Otten "pierrebourgault" wrote in message ... There are examples in the Help but none works. I should be able to do =text(A3, "ddd") or =text(A3, "dddd") : I get an error message saying that the formula has error. Obviously there is no indication what the error is. I am using Excel 2003. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert a date into the day name in Excel ?
With all due respect to Niek's response, may I beg to differ? Rather
than re-enter all the dates, you may be able to parse the text entries into Excel-recognized dates using MID, RIGHT, LEFT functions in conjunction with MONTH, DAY, and YEAR functions. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert a date into the day name in Excel ?
You can just use the Format Cells command, choose NUmber then Custom and set
to dddd or ddd as required. "pierrebourgault" wrote: There are examples in the Help but none works. I should be able to do =text(A3, "ddd") or =text(A3, "dddd") : I get an error message saying that the formula has error. Obviously there is no indication what the error is. I am using Excel 2003. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
excel array formula | Excel Worksheet Functions | |||
Launch excel showing today's date | Excel Discussion (Misc queries) | |||
format date in excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |