Dates not showing correctly on x-axis

This is somewhat of a complicated problem so I will do my best to explain it. I am trying to make several charts, they need to be auto-scaling and dynamic. I have it worked out to where it auto-scales and is dynamic based on the date range you want. However, it will not show the dates properly. Example: if you enter start date of 6/17/2013 and you want to view data for 2 days, it shows up properly in the chart, except the dates on the x-axis say "1/0, 1/10..." instead of "6/15, 6/16, 6/17". Any help is appreciated.


excel.xlsx

I was able to fix this by using the name manager and naming the dates as DateCST setting the x-axis as =OFFSET(Calc!$A$1,COUNT(Calc!$A:$A)-Calc!$J$2,0,COUNT(Calc!$A:$A)-1)

On the Calc page I did a count function for the A column in cell J2 so
"-Calc!$J$2" is how many cells to display on the chart.

So select data, x-axis values =Calc!DateCST fixed the problem. It is a useful chart if anyone wants to use it. I can email a working copy if anyone is interested.