Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

"Years" section of date advancing instead of "days" section when dragged?

Hello, when I drag the corner of a cell containing a date to produce more dates below, the "years" section of the date advances by one for each cell it is dragged into instead of the "days" section.

All cells (including the one containing the original date) are formatted for date and formatted DD/MM/YY.

I haven't had this problem in the past so am unsure what has caused this.

Thanks for any help.