Week to be derived based on FY start day condition

[dhavalvyas]

Hi.

I have an requirement to calculate week of the year if suppose 1st April starts after Wednesday then first week should be considered till next Saturday.

Please look at example given below :

Eg :

• 1st April is on Thursday then first week should be from 1st April Thursday to 10th April Next week Saturday.
• Second week is as usual(Sunday to Saturday) from next day i.e. 11th April Sunday to 17th April Saturday.
• Third week is as usual (Sunday to Saturday) i.e. 18th April Sunday to 24th April Saturday.

[ogster1974]

try

Div(TempDate-YearStart(TempDate,0,4),7)+1 as FiscalWeek

in your calendar

[dhavalvyas]

Hi this solution is not working, my requirement is if it starts after Wednesday, then it should count first week till next week's Saturday.