=text(MONTH(TODAY())+1,"MMM")&" "&"Sales"

Just another option:

=TEXT(EOMONTH(TODAY(),1),"mmm") & " Sales"

--
Dana DeLouis


"Christopher Naveen" wrote in message ...

Hi,

Pls. refer the below mentioned formula. I wanted the Text to Display as "Oct
Sales" (means referring to the next month). I tried a lot using this formula
but can't able find a solution. Can anybody help me on this?

=text(MONTH(TODAY())+1,"MMM")&" "&"Sales"

Thanks in Advance!

-Christ