dynamic date filter

Hi all,

I have a query which has a date column, which has date from 2000.01.01 to 2099.12.31. I want to filter the date from 2016.01.01 till now.

I therefore write in the M code as

= Table.SelectRows(#"Renamed Columns", each[Date] < Date.From(DateTime.LocalNow()) )

= Table.SelectRows(#"Filtered Rows", each [Date] >= #date(2016, 1, 1))

Then due to analysis requirement, I need the date list to be from 2016.01.01 till 21 days into the future. How should I modified the first M code so that it is possible?

I tried with Date.From(DateTime.LocalNow()+21), but it was obviously not working....

Thanks in advance.