Hello,

I'm using Excel 2007 and would like the dates to appear as: Jun/01, Jun/02,
Jun/03, Jun/04, Jun/05, Jun/06, Jun/07, Jun/08, Jun/09. I entered the first
date in cell B2 as such 6/01/01 and custom format as mmm/yy.

I go to cell C2 and enter a formula =B2+365 so it will display as Jun/02.
Everything is fine until I get to cell E2 which should display Jun/04, but
instead it displays as May/04. The formula contains =D2+365.

Why did the month change? I need to plot dates in a bar chart with the
following dates: 6/01/01 through 6/01/09 in Jun/01 through Jun/09 format.