Power query Date Table function

I've beeb trying to write a date function for power query I've got as far as ;

Please Login or Register  to view this content.

Which works but I'm stuck at two things, one I thought I should be able to define the function as a table ;

Please Login or Register  to view this content.

but can't get it to work I've tried nestign let / in statements but not got it right.

Also I'd lke to add more columns, for year , month etc. but keep getting errors, I've tried ;

Please Login or Register  to view this content.

I've tried wrapping the whole thing in Table.AddColumn, but this didn't work and would be very impractical for adding lots of columns,
I've attached workbook showing errors and would like some help on how to write this.

Richard.

I'm not gettig back column for 'names' of day, I've use the follwing;

Please Login or Register  to view this content.

It's the day and month names wich aren't coming through, both work fine in addcolumns, on the 'invoked table',

any ideas as to why this should be, I did get day name to work on it's own, just adding one column to what you
gave me, I've attached the workbook with the above code and the added custom column.

Richard

Ooops.

I did get it working, I typed it up in notepad and then pasted it in, I often find that easier.

BTW what breed is the dog in the photo? I thought a Lab but not sure.

R

Well looks a lovely dog, I'm biased toward labs,

Thanks for introducing Table.FromColumns, I made the mistake of using double {{}} around the whole thing at first, which returns a list of dates in column1, and the word date in column2.

then scrolled down a bit further in MS Docs, still at least if I ever need a list of date.........

Richard