| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert number to month and year in formula
you guys are the best ! thanks.
"Ron Coderre" wrote: Depending on what kind of value you want: For a number between 1 and 12, inclusive, in A1 Date value: B1: =DATE(YEAR(TODAY()),A1,1) Format B1 as a date: mmmm yyyy or for a text value: B1: =TEXT(A1&"/1/"&YEAR(TODAY()),"mmmm yyyy") Does either of those help? *********** Regards, Ron XL2002, WinXP "Soth" wrote: Hi How do I wright a formula by converting number 1 to January 2006, Number 2 to February 2006 and soforth? Thanks Soth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| holiday dates | Excel Worksheet Functions | |||
| Display number of day of month depending on the year | Excel Discussion (Misc queries) | |||
| HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
| How do I convert a serial number to the month, day, and year in E. | Excel Discussion (Misc queries) | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Hybrid Mode
