The following works if the month name is the same for the entire sheet.
A1 =CELL("Filename")
A2 =FIND(".";A1)
A3 =FIND("January";A1)
A4 =MID(A1;A3;A2-A3)
A5 =FIND("/";A4)
A6 =RIGHT(A4; LEN(A4)-A5)
Change A3 to point to a cell where the month is located rather than hard
coding it. You can probably combine the six formulas into one long formula.
--
Dennis
Disclaimer: The above is my opinion. I do not guarantee it. Be sure to back
up any files involved and use at your own risk. Batteries not included. Not
for internal use. Don't run with knives.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
