| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Number to Month in Text Problem
I am having an issue with converting the month number to the month
abbreviation. Below Should Return "Feb", but it is returning "Jan" 1.) ="Jobs Due In or Before "& TEXT(TODAY(NOW()),"mmm") Below Should Return "Mar", but it is returning "Jan" 2.)="Jobs Due In "& TEXT(MONTH(TODAY())+1,"mmm") 3.)="Jobs Due After " & TEXT(MONTH(TODAY())+1,"mmm") My computer time is set to Thursday, Feb. 27, 2008. Anybody have any ideas? Thanks Ryan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting month name to number | Excel Worksheet Functions | |||
| Converting month name to number | Excel Worksheet Functions | |||
| Converting Month Number to Month Text Abbreviation | Excel Worksheet Functions | |||
| converting Month name to a number | Excel Discussion (Misc queries) | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
Threaded Mode
