Yeah but assumes Aug. Mine will work with Aug, Sep, etc, which I am sure is
what the OP would want. Put that back in and it is no shorter.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Krishnakumar"
wrote in message
news:Krishnakumar.1taimi_1123243557.8972@excelforu m-nospam.com...
Hi,
I think Bob's formula can be shortened to like this,
=IF(RIGHT(x,2)="01","",INDIRECT("Aug"&TEXT(--RIGHT(x,2)-1,"00")&"!D5"))
where x,
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
HTH
--
Krishnakumar
------------------------------------------------------------------------
Krishnakumar's Profile:
http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=393232