Week Range to Start from Thursday and end on Wednesday

[lakshmanvepuri]

Hi ,

I would to change the WeekStart and Weekend as Customized as per the Standards.

I am able to get the week start and week end range as  below

dual(Date(WeekStart([INFORM_DATE]),'MMM DD') & ' - ' & Date(WeekEnd([INFORM_DATE]),'MMM DD') ,Week([INFORM_DATE])) as week_range.

Result for February

Feb 01 - Feb 07

Feb 08 - Feb 14

Feb 15 - Feb 21

I want the week range should start from Thursday and end on Wednesday.

Jan 28 - Feb 03

Feb 04 - Feb 10

Feb 11 - Feb 17

Feb 18 - Feb 24

Please advise me how to achieve that..?

Thanks a lot.

regards

Lakshmana

[sunny_talwar · Accepted solution]

Try this:

=Dual(Date(WeekStart([INFORM_DATE], 0, 3), 'MMM DD') & ' - ' & Date(WeekEnd([INFORM_DATE], 0, 3), 'MMM DD') , Week([INFORM_DATE]))

[#3]

Hi Sunny,

I have same requirement like above, but in my scenario I want to show number of records as well in that particular week (last week or previous week)

In my scenario my week starting from Friday and Ending on Thursday and I am trying to calculate in expression, but didn't succeed, need help here.