convert date to name of month*Dave Peterson
THANK YOU!
"Dave Peterson" wrote:
=if(a1="","",text(date(2009,a1,1),"mmmm"))
Is one way.
holly wrote:
My spreadsheet:
A B
Results: C
1/5/09 =IF(A1="","",MONTH(A1)) 1
?
In Column C, I need to write a formula that says =IF($B1=1,"January"...)
but my statement if FALSE, needs to be, IF($B1=2,"February" and so forth all
the way through the calendar. The false will be if a new IF formula.
I started with this,
=IF($B1=1,"January",IF($B1=2,"February",IF($B1=3," March")))
And all the way down the line to December, with the correct # of close
parens (12 of them) but I get an error. Do I need to keep typing in the "IF"
for a false statement? Help please :)
--
Dave Peterson
|