+ Reply to Thread
Results 1 to 9 of 9

Sequential dates

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    Sequential dates

    Hi,

    I hope I am posting this in the correct forum, and apologist if I haven't. I've searched for this particular problem on the forums but couldn't find an answer.

    I am using Excel 2007 and want to produce a column of the dates in a given month (ie first to last). I have followed videos on the internet which say to insert the first date, then drag down and autofill will do the rest, but it doesn't change the day or the month - only the year.

    If anyone could suggest what I am doing wrong, I would be very grateful.

    Cheers.

  2. #2
    Registered User
    Join Date
    12-20-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    78

    Re: Sequential dates

    If the cells are formatted as text it will only change the year. If they are formatted as date it should change the day instead.

  3. #3
    Registered User
    Join Date
    08-04-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sequential dates

    The dates are formatted as 'date', not text.

  4. #4
    Registered User
    Join Date
    12-20-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    78
    Quote Originally Posted by cartoonist View Post
    The dates are formatted as 'date', not text.
    Must be something with 2007 it works in The latest version of Excel. I tried it. Hope you figure it out.

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,499

    Re: 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.
    Dave

  6. #6
    Registered User
    Join Date
    08-04-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sequential dates

    Thanks for that Dave - I hope I've attached it correctly.

    Cheers.
    Attached Files Attached Files

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    21,984

    Re: Sequential dates

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



  8. #8
    Registered User
    Join Date
    08-04-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Sequential dates

    Thanks, Glenn. That worked perfectly.

    Cheers.

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    21,984

    Re: Sequential dates

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1