I am having trouble even explaining what I want but here it goes...

What I have:
I have one file saved on a network share, the path is: //network01/share/seating chart/Seating Chart.xlsx

This file has the date stored in cell S1 (this can be changed if needed to have S1 = Month, S2=Day, S3=Year if needed)

The users at work modify this Seating Chart.xlsx file for the upcoming days and save them in the seating chart directory under the subfolder //network01/share/seating chart/2015(year)/05(month)/5-25.xlsx (or some variation)

I am hoping to automate this process with a macro/button/etc so that when the Seating Chart is saved, it saves in the /year/month subfolders based on the cell value, NOT the current date, since some of these may be saved days in advance.

For example, today a user is creating a seating chart for May 30, when they finish, I would like for it to be saved to the path:
//network01/share/seating chart/2015/05/05-25-2015.xlsx (the final format doesn't have to look like that as long as I know the day

Any help would be greatly appreciated.

Jeremy