 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2006Day 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??? Hi, format as dddd hth  Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > Is there a formula or function that will tell me the day of the week > associated with a date i enter in excel??? Assuming your date is in cell A1, try =TEXT(A1,"dddd") HTH Rob > Is there a formula or function that will tell me the day of the week > associated with a date i enter in excel??? 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 Is there a formula or function that will tell me the day of the week associated with a date i enter in excel??? Hi Format>Cells>Number>Custom>dddd dd mmm yyyy Choose whatever format you prefer. SignatureRegards Roger Govier > Is there a formula or function that will tell me the day of the week > associated with a date i enter in excel??? 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 Hi Format>Cells>Number>Custom>dddd dd mmm yyyy Choose whatever format you prefer. SignatureRegards Roger Govier > Is there a formula or function that will tell me the day of the week > associated with a date i enter in excel??? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.