Excel question

Remove this Banner Ad

X_box_X

The Opportunist
Mar 15, 2001
21,408
31,010
DogLands
AFL Club
Western Bulldogs
Other Teams
Chelsea
Instead of manually entering the order of dates throughout the year in descending cells, is there a code that allows you to click and drag that automatically enters chronological dates per day rather than per month?

I.e.

1601745886264.png


I have manually entered those dates. If I click and drag from cell 101 to cell 102, the 102 cell becomes Nov-08 instead of Oct-09.

Please help. :)
 

Count Zero

Premiership Player
Jun 16, 2004
3,525
270
Adelaide
AFL Club
Port Adelaide
Other Teams
Port Adelaide Est.1870
Instead of manually entering the order of dates throughout the year in descending cells, is there a code that allows you to click and drag that automatically enters chronological dates per day rather than per month?

I.e.

View attachment 976981

I have manually entered those dates. If I click and drag from cell 101 to cell 102, the 102 cell becomes Nov-08 instead of Oct-09.

Please help. :)
When I want to do this I type the first value (either date or number) in the first cell, then select the cell range. From the Home menu choose "Fill" then "Series".
 

Log in to remove this ad.

Similar threads

Remove this Banner Ad

Remove this Banner Ad