Fiscal year Calculation in weeks

[Ayodeji_Osikoya]

Hi,

Normal week number starts in January. So the week of January 1 is week 1 and the week of December 31 is week 52

Is it possible to make February 1 the beginning of the year so that February 1 becomes week 1 and the week of January 31 becomes week 52?

Thank you

[Yoichi]

Hi,

Can you try the following sample?

Enumerable.Range(1, Cint(Math.floor((targetDate-startDateOfFY).TotalDays))).Select(Function(i) startDateOfFY.AddDays(i)).Where(Function(d) d.DayOfWeek = DayOfWeek.Sunday).Count+1

Main.xaml (6.2 KB)

Regards,