Month based on number

[tycasey17]

I have on one tab =MONTH(TODAY)) which displays the number of the month and I want to use that reference on another tab to spell out the month. Every time I try to use =TEXT(Data!A1,"mmmm") it just spells January. How do I fix this?

 

[BigBeachBananas]

I have on one tab =MONTH(TODAY)) which displays the number of the month and I want to use that reference on another tab to spell out the month. Every time I try to use =TEXT(Data!A1,"mmmm") it just spells January. How do I fix this?

Try:
=TEXT(Data!A1*29,"mmmm")

 

[tycasey17]

Worked perfectly...thank you for the help