Forum

Dynamic Date Table ...
 
Notifications
Clear all

Dynamic Date Table - week ending Saturday not Sunday

2 Posts
2 Users
0 Reactions
85 Views
(@sharleena)
Posts: 3
Active Member
Topic starter
 

Hi

I've just created the dynamic date table per session 4.13, love it!

However our weeks end on Saturday here oddly for timesheet purposes, when I use the add column for week end it automatically brings in the Sunday date.  Is there a way I can bring in the Saturday week ending?

Thanks

 
Posted : 12/05/2018 5:24 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Sharleen,

Welcome to our forum 🙂

In Excel, first day of week is used, not the last. Same in Power Query, here is a resource for that:

Power Query - date-startofweek

 
Posted : 12/05/2018 4:19 pm
Share: