Create a list

[ExcelQuestion]

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



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

 

[Bill Szysz]

Try this one below (without calendar table)

Regards

 

[ExcelQuestion]

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

 

[p45cal]

[just practising on these old threads]

Similar to Bill's without List.Generate.

 

[ExcelQuestion]

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

[just practising on these old threads]

Similar to Bill's without List.Generate.