Excel question

Remove this Banner Ad

X_box_X

King of September
Mar 15, 2001
20,044
14,020
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,482
173
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.

Remove this Banner Ad