| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a month name from its number
If I evaluate month(7/7/2008) I get the number 7.
Apart from a whole bunch of nested if statements or something, how would I get "July" instead? Is there a built in function that does that? This is in the context of a formula: ="Asset based fee for "&MONTH(B2)&" "&YEAR(B2) Which displays "Asset based fee for 7 2008", where I'd like it to say "Asset based fee for July 2008". Travis |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Writing a month name from its number
try this
="Asset based fee for "& TEXT(B2,"mmmm") &" "& TEXT(B2,"yyyy") -- Gary "travis" wrote in message ... If I evaluate month(7/7/2008) I get the number 7. Apart from a whole bunch of nested if statements or something, how would I get "July" instead? Is there a built in function that does that? This is in the context of a formula: ="Asset based fee for "&MONTH(B2)&" "&YEAR(B2) Which displays "Asset based fee for 7 2008", where I'd like it to say "Asset based fee for July 2008". Travis |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Writing a month name from its number
="Asset based fee for "& TEXT(B2,"mmmm yyyy")
or even =TEXT(B2,"""Asset based fee for ""mmmm yyyy") -- __________________________________ HTH Bob "travis" wrote in message ... If I evaluate month(7/7/2008) I get the number 7. Apart from a whole bunch of nested if statements or something, how would I get "July" instead? Is there a built in function that does that? This is in the context of a formula: ="Asset based fee for "&MONTH(B2)&" "&YEAR(B2) Which displays "Asset based fee for 7 2008", where I'd like it to say "Asset based fee for July 2008". Travis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
| Converting Month Number to Month Text Abbreviation | Excel Worksheet Functions | |||
| Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
| show month number as month name in Excel? | Excel Discussion (Misc queries) | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
![travis[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
