Excel: display dates consistently in a planning sheet

Date appearance depends on formatting and regional settings. A date typed in an ambiguous format may be interpreted differently on another device.

How to display dates consistently in a planning sheet

  1. Use a copy of the planning sheet for testing.
  1. Select the date cells and open the number-format or Format Cells options.
  1. Choose a clear date format with an unambiguous month, such as 17 Nov 2026.
  1. Check the underlying dates are recognised as dates rather than text, especially after importing data.
  1. Review a few early and late dates before sorting, filtering or sharing the sheet.

Practical guidance

Date display depends on the cell format and sometimes regional settings. A value that looks like a date may actually be text.

If the usual instructions do not resolve it

Test sorting on a copy of the sheet and use a consistent unambiguous date format for shared school planning.

Still need help?

If a date has already been interpreted incorrectly, formatting alone may not fix it. Give IT a harmless example and the expected date.

Official product help

Still need help?

Send a request and include the steps you already tried.

Submit a ticket

Rate this article

How useful was this article?
Add a correction or suggestion (optional)
Do not include passwords, pupil details, or other private information.