Remember that MONTH() will give the number 5. If you want "May" you may
prefer =TEXT(Serial_Number,"mmmm").

To use the result in your reference, I assume you realise that you'll need
the INDIRECT() function.
--
David Biddulph

"rachel" wrote in message
...
I want to use the value of the MONTH function within a formula to refer to
a
sheet in another workbook eg ='May'! where the reference May comes from
the
result of =MONTH(Serial_Number)

Any ideas please

--
Many Thanks
Rachel