Results 1 to 5 of 5

Thread: Create a list

  1. #1
    Acolyte ExcelQuestion's Avatar
    Join Date
    May 2018
    Posts
    24
    Articles
    0
    Excel Version
    Office 365

    Create a list



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Happy New Year, Experts!!!

    Stumped. Is it possible to create a list...
    1) incremented by Month and,
    2) keep the day to be the same day as the source's [Start] column

    Click image for larger version. 

Name:	Next Challenge.JPG 
Views:	21 
Size:	81.5 KB 
ID:	8755

    I've tried List.Dates but it only allows the increment by Day, not by Months. I've tried List.Generate with Date.AddMonths but resulted in Errors (file is attached)

    Could you please help me?

    Thanks in advance,
    Ricky
    Attached Files Attached Files

  2. #2
    Conjurer Bill Szysz's Avatar
    Join Date
    Apr 2016
    Location
    Poznań, Poland Dublin, Ireland
    Posts
    112
    Articles
    0
    Excel Version
    Excel 365
    Try this one below (without calendar table)

    Regards :-)
    Attached Files Attached Files

  3. #3
    Acolyte ExcelQuestion's Avatar
    Join Date
    May 2018
    Posts
    24
    Articles
    0
    Excel Version
    Office 365
    Thank-you Bill....a million times! You've saved me tremendously.

    Such a nice New Year's gift.

    I'll do some research to understand that List.Generate M code. It works perfectly.

    Thanks again Bill.

    Regards,
    Ricky

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,740
    Articles
    0
    Excel Version
    365
    [just practising on these old threads]

    Similar to Bill's without List.Generate.
    Attached Files Attached Files

  5. #5
    Acolyte ExcelQuestion's Avatar
    Join Date
    May 2018
    Posts
    24
    Articles
    0
    Excel Version
    Office 365
    Thank-you p45cal.
    It looks great! I've learned a lot you and Bill utilize this incredible List.Generate function.

    I appreciate your answer file. It helps so much.

    Take care and be safe.

    Best regards,
    Ricky

    Quote Originally Posted by p45cal View Post
    [just practising on these old threads]

    Similar to Bill's without List.Generate.

Posting Permissions

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