Howdy, folks:
I have a series of workbooks, each within a "month" directory - for example: "Jan 11", "Feb 11" - in the format of "mmm yy". I'm looking for a way for each workbook to look to it's directory and come up with an associated date. As an example, the file within the "Mar 11" folder would look at it's location and return a date of "03/01/2011" in the format of mm/dd/yyyy. A function, perhaps? Any ideas?
TIA.
Bob
Bookmarks