I keep running into this problem and it's driving me nuts, I can't find an explanation for it.
I have charts that must auto range the Min and Max dates.
Half the time it seems to work and then half the time Excel randomly changes my chart dates to be one day earlier than the date range, and I have no clue why?
Bookmarks