I have a file I have been working on that includes different sheets for each day of the week with formulas that flow to another sheet that is kind of like a tally sheet for two weeks.

My issue: Right now I have each sheet numbered for the sheet name "1" through "14". It would be great to have the sheets name themselves as a date based on a date entered on the tally sheet, i.e. "12/07" as the name for sheet one through "12/20" for the last sheet name, without having to actually type the dates in for each sheet.

Is there a way to input a formula somehow to do this? I really am trying to avoid macros. I am setting this up for users who are not particularly Excel savy...

Any help or ideas would be greatly appreciated.