I'd put today's date in that named cell instead:
say A1 contained a formula like: =today()

Then I'd use:

=INDIRECT.EXT("'"&LEFT(CELL("FILENAME",A1),
FIND("-",CELL("FILENAME",A1))-3)
&TEXT(a1-day(a1),"mm-yyyy")&".xls]Monthly Summary'!b37")

I removed the $ from inside the text and joined the strings together, too.

and
=a1-day(a)
will return the last day of the previous month of the date in A1.


Sandy wrote:

Hello
I have a monthly file My File mm-yyyy.xls. I am trying to reference last
months file using cell C1 (Named month) and indirect.ext using
cell("FILENAME'). The month portion of the formula is evaluating to 01 no
matter the month.
My formula:
=INDIRECT.EXT("'"&LEFT(CELL("FILENAME",A1),FIND("-",CELL("FILENAME",A1))-3)&TEXT((MO-1),"MM")&"-"&YR&".xls]Monthly Summary'!$"&"b$37")

What should I change in TEXT((MO-1) so it will evaluate to the previous
month. I realize that January will be a problem and plan on manually
entering the values unless some one has a suggestion for that too.

Thanks!!!

--

Dave Peterson