Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Henric Cronstrom hic has some excellent blogs on Calendars & Week Nos
Henric Cronstrom hic has some excellent blogs on Calendars & Week Nos