Hi Deepak,

1. as regards your first part of the post, u can use the following :
=TEXT(a1,"mmmm")

2. as regards your second part of the post, u can use something like
this :
=IF(A1=1,1.3%,"")&IF(A1=2,3%,"")&IF(A1=4,6.5%,"")& IF(A1=5,2.2%,"")&IF(A1=6,4.4%,"")&IF(A1=9,7%,"")&I F(A1=10,7.5%,"")&IF(A1=11,8.8%,"")&IF(A1=3,3.5%,"" )&IF(A1=12,4.9%,"")&IF(A1=13,1%,"")&IF(A1=7,1.6%," ")&IF(A1=8,6.25%,"")

click yes below, if it helps
"deepak" wrote:

Hello!

1 Suppose A1 has date in format dd-mm-yy , say 12-DEC-09. How can I have
extract only DEC from A1?

2 I get stucked whenever there is more than eight IF in the neseted IF
statement. Cannot we have more than 8 IF?

Please help me out.

Thanking you.