View Single Post
  #6   Report Post  
Max
 
Posts: n/a
Default

"Shakespeare" wrote:
....

=IF((MONTH(A3))=7,"July",IF((MONTH(A4))=8,"August" ,IF((MONTH(A19))=9,"Septem
ber",IF((MONTH(A23))=10,"October",IF((MONTH(A21))= 11,"November",IF((MONTH(A2
6))=12,"December",IF((MONTH(A11))=1,"January","
No Month")))))))

.....
There has got to be an easier way to do this.


Think we could try just something like:
=TEXT(A1,"mmmm")
where A1 contains a date

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----