Hi
are the underlying date values correct? sometimes they are not, if data are imported from elsewhere. If Excel thinks your 1 March 2014 is actually 3 January 2014 they you're goung to have to change the date values themselves. Otherwise, you can just change the date format in the cell.