Good Morning

If I have a macro that creates a folder baseed on the contents of several cells, what line of code could I use to copy that final file path through to the sheet in cell F2.

The start location would be for example C:\

It then looks for a current year folder, a current month folder and then the previous working day folder if any one of those dont appear then it creates it, so i just want the end path that would look something like C:\2014\august\26th

Thanks Dave