really need more info to help you. ideally a sample sheet (without private info). But first thing I would check is that the 2 dates are in fact dates and not text. What happens if you change the format from short to long date, does it change? what if you subtract the 2 dates?