View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deepak Deepak is offline
external usenet poster
 
Posts: 47
Default extracting only month from a date

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.