| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Day of the week
Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day of the week
Hi,
format as dddd hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Negin" escreveu: Is there a formula or function that will tell me the day of the week associated with a date i enter in excel??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day of the week
Assuming your date is in cell A1, try =TEXT(A1,"dddd")
HTH Rob "Negin" <Negin @discussions.microsoft.com wrote in message ... Is there a formula or function that will tell me the day of the week associated with a date i enter in excel??? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day of the week
If you want a formula, would you like to try the following.
For today's date: =TEXT(WEEKDAY(TODAY()),"dddd") For any date that you key into A2 (e.g. 10/1/2006): =TEXT(WEEKDAY(A2),"dddd") You can key the formula into B2 to have "10/1/2006" and "Sunday" side by side. See Excel Help for more details on WEEKDAY( ). Hope this helps. Epinn "Negin" <Negin @discussions.microsoft.com wrote in message ... Is there a formula or function that will tell me the day of the week associated with a date i enter in excel??? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day of the week
Hi
FormatCellsNumberCustomdddd dd mmm yyyy Choose whatever format you prefer. -- Regards Roger Govier "Negin" <Negin @discussions.microsoft.com wrote in message ... Is there a formula or function that will tell me the day of the week associated with a date i enter in excel??? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Day of the week
Yes, Roger, I would do the same too. I have been thinking why a formula is needed and the only situation I can think of is that this is within another formula. Any comments?
Hope you are enjoying your weekend. Epinn "Roger Govier" wrote in message ... Hi FormatCellsNumberCustomdddd dd mmm yyyy Choose whatever format you prefer. -- Regards Roger Govier "Negin" <Negin @discussions.microsoft.com wrote in message ... Is there a formula or function that will tell me the day of the week associated with a date i enter in excel??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation List | Excel Worksheet Functions | |||
| Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
| Macro to insert copied cells | Excel Discussion (Misc queries) | |||
| user defined function | Excel Worksheet Functions | |||
| Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
Hybrid Mode
