Forum Discussion
Formatting Dates in Cells - subsequent year.
Hello - I'm using the formula ddd, dd-mmm (e.g. Wed, 10-Apr) to create a spreadsheet with a date column. I've started with June 2024, and want to go through to July 2025. When I use the same formul...
Specify the year explicitly when you enter the dates, even if the year is not displayed in the cells.
If you enter a date without specifying the year, Excel assumes that it is in the current year.