I'm not sure if this is possible but I thought I would ask to see if any one may have a solution.

Issue:
I have a macro were the user inputs a date as a string (e.g. 021513) in an input box. It is in string format as it's used to open a file (string at the end of the file name).

From this string (e.g. 021513) I need to derive the following in two separate fields:

* Week period (e.g. Week: 11th - 15th).
* Month (e.g. February).

Any help or thoughts would be greatly appreciated.

Ciaran