Wouldn't that return the answer 12, rather than DEC?
--
David Biddulph

"Atishoo" wrote in message
...
=MONTH(A1).

"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.