Fiscal year Calculation in weeks

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,

2 Likes