I have a schedule in a worksheet containing alternating columns of successive events and their dates: each date is later than the dates to its left in the same row. At this time of the year there is a problem because unless you enter the year, Excel assumes that months in the new year are instead in 2014. So: Event 1, in date cell type ?11/11? ? displays ?11.11.14?. Event 2, in date cell type ?12/12? ? displays ?12.12.14?. Event 3, in date cell type ?1/1? ? displays ?1.1.14?. I realise (as well as typing the three extra characters /15) I could have a second column each time subtracting 365 but that?s too elaborate. Is there a quiet, simple solution?
This question generated 11 answers. To proceed to the answers, click here.
This thread is current as of November 27, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel