excel changes dates when sorting

[terryberry]

When I sort my date column (it is formatted correctly), excel changes the dates on some of the entries. There is no consistency to it - it could be a few dates will come out three days later one time, and some others will be four days earlier another. Why does excel do this and how can I fix it?

 

[texasalynn]

Welcome to MrExcel board....

a couple of things come to mind
1) there are formulas in the areas you say change that are dependent on the data that is sorted
2) you haven't selected all of the combined area to sort together

 

[terryberry]

Thanks! Your second suggestion did the trick! Saved us a lot of future aggravation.