Entering dates in Cells beyond year 2024

Copper Contributor

I am trying to make date ranges that range from dates of the year in 2024 to 2025 and so on. Every time I enter a date with 2025 in it, it changes the date back to 2024. How do I fix this to enter dates in 2025 and 2026? Please help!

1 Reply


What happens if you enter 12-Mar-2025 in a cell and press Tab or Enter?