| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert number to month and year in formula
Hi How do I wright a formula by converting number 1 to January 2006, Number 2 to February 2006 and soforth? Thanks Soth |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert number to month and year in formula
=DATE(2006,your_number,1)
So, DATE(2006,1,1) will output January 2006 DATE(2006,2,1) will output February 2006. If you have a list of cells with 1,2,3, etc, say A1:A100, you can put the formula =DATE(2006,A1,1) in cell B1 and drag down. Does that help? -- Regards, Dave "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert number to month and year in formula
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 |
|
#4
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 | |||
Linear Mode
