Given a date, say 11/12/2006, how can "Nov" be returned. I know =MONTH(A1)
would return 11 if 11/12/2006 is in A1. So I have a formula
=VLOOKUP(MONTH(A1),'Mth Lookup'!$A$1:$B$12,2,FALSE) which returns Nov if
MONTH(A1) = 11, and so on. But this seems rather cumbersome.

Is there a more direct way to do this?

Dave
--
Brevity is the soul of wit.