Sequential dates

@ cartoonist

I'd have to see this in context. What you describe should work. There must be some "hidden" issue. This would best be resolved with a sample of misbehaving Excel file .... please not screen shots or pics. If you are not familiar with how to do this:

(Of note: The 'paperclip' icon has not worked for some time. So please save yourself some grief.)
To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

Enter your dates with / as separator not . Then it's fine. so 1/9/2019 and drag down.

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.