Hi

Something like

=INDIRECT(TEXT(TODAY(),"mmmm") & "!A1")


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"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