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
|