Week No but for Monday Start

ivandrago — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the attached Document which has a calendar table. What I am after is the Week No which starts from Monday and ends in Sunday.

So if you look at the attached spreadsheet (WeekNo_Monday_Start) this is the Week No's I want against the Date range (01/08/2017 to 01/11/2017).

So if we are in a new month and the the first day lets say is Sunday then I would want it to show as Week No 1, but the next date would be on a Monday so I would want the Week No to be 2 for all the dates till that week coming Sunday.

I currently have a "Week No" field and I tried to do the logic on the field called "New Week No" but struggling to do this.

Thanks

Re: Week No but for Monday Start

Colin-Albert — Mon, 25 Sep 2017 16:32:36 GMT

Henric Cronstrom hic has some excellent blogs on Calendars & Week Nos

Redefining the Week Start

Redefining the Week Numbers

topic Re: Week No but for Monday Start in QlikView

Week No but for Monday Start

Re: Week No but for Monday Start