 |
 | 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 / January 2004Day and Month Names
I know I can use month(ref) to get the month number, but is there a function to return the month name? i.e. function(2) = February? I know I can format the cell as "mmmm" to just display the month on its own, but I need to incorporate it into a string on other text. RG, Yes, it's the ubiquitous TEXT function =TEXT(A1,"mmmm") gives February =TEXT(A1,"mmm") fives Feb  SignatureHTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) > I know I can use month(ref) to get the month number, but is there a function to return the month name? i.e. function(2) = February? > I know I can format the cell as "mmmm" to just display the month on its own, but I need to incorporate it into a string on other text. > I know I can use month(ref) to get the month number, but is there a function to return the month name? i.e. function(2) = February? > I know I can format the cell as "mmmm" to just display the month on its own, but I need to incorporate it into a string on other text. If you are starting with a date (say in A1), you can use the TEXT function. For example, =TEXT(A1,"mmmm") will give the full name of the month (such as "January"). =TEXT(A1,"ddd") will give the abbreviated weekday (such as "Wed"). Hi =TEXT(YourDate,"mmmm") where YourDate is reference to date value, or some function returning date. Signature(When sending e-mail, use address arvil@tarkon.ee) Arvi Laanemets > I know I can use month(ref) to get the month number, but is there a function to return the month name? i.e. function(2) = February? > I know I can format the cell as "mmmm" to just display the month on its own, but I need to incorporate it into a string on other text. |
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.