Hi,

I was told that if I followed these steps below, i can get a rolling calendar that starts on 1-1-2018. And it ends on TODAYs date.

   1 . Click on Data > New Query > From Other Sources > Blank Query

   2 . In the formula Bar type =#date(2018,1,1)

   3. Press Enter on your keyboard.

   4. Click on the fx icon on the formula bar

   5. Type this formula   List.Dates (Source, Number.From(DateTime.LocalNow()) - Number.From(Source), #duration(1,0,0,0))

   6. Convert the resulting list into a table List Tools > To Table

Is there any way I change this so it starts on 1-1-2018 and it:

a) continues 2-1-2018, 3-1-2018, etc

b) and it ends on 12-1-2028?

Please advise.

Thank you

Celeste