Excel Power Query, group by 2 weeks

[shophoney]

Hi, I'm wondering if there is a way to group sales by every 2 weeks.

I have a list of sales by day. I want to group every 2 weeks.

I also have created a PQ calendar table. I could create the group by there, based on 14 days? Count of days????

Thanks

 

[sandy666]

Duplicate

PQ grouping 2 weeks

Hi, I have created a power query calendar. I need to group 2 weeks at a time for payroll. Starting on Mondays. How can I make a grouping interval be 14 days starting on Mondays.

www.mrexcel.com