Text Formula
 

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

Text Formula
 

=CHOOSE((MONTH(TODAY())+1),"JAN","FEB","MAR","APR" ,"MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC")& " Sales"

Month returns a value ie 9

"Christopher Naveen" wrote:

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

Text Formula
 

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),"mmm" ) & " Sales"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

Text Formula
 

=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

Text Formula
 

If you put the formula =MONTH(TODAY())+1 in a cell, and format it first as a
number (or general) and then as a date, then you may see what is going
wrong.
Then try the same with =DATE(YEAR(TODAY(),MONTH(TODAY())+1,1)
--
David Biddulph

"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

Text Formula
 

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


"Christopher Naveen" wrote:

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