Semister Year format and Number of days calculation by excluding Weekend in SSRS report

//Semister year form date

=iif( (month(now())>=4 and month(now())<=9), CDate("4/1/" & cstr(year(now()))), CDate("10/1/" & cstr(year(now())-1)))

//Semister year todate

=iif((month(now())>=4 and month(Now())<=9), CDate("09/30/" & cstr(year(Now()))), CDate("03/31/" & cstr(iif(month(Now()) <= 3, year(Now()), year(Now())+1 ))))

//Exclude weekend

= (DateDiff(DateInterval.day,Parameters!BeginDate.Value,Parameters!EndDate.Value)+1)

- (DateDiff(DateInterval.WeekOfYear,Parameters!BeginDate.Value,Parameters!EndDate.Value)*2) 

- IIF(Weekday(Parameters!BeginDate.Value,1) = 1,1,0)

- IIF(Weekday(Parameters!BeginDate.Value,1) = 7,1,0)

- IIF(Weekday(Parameters!EndDate.Value,1) = 1,1,0)

- IIF(Weekday(Parameters!EndDate.Value,1) = 7,1,0)

------OR------OR------------OR----------------------

=(DateDiff(DateInterval.day,Parameters!STARTDATE.Value,Parameters!ENDDATE.Value)+1)

-(DateDiff(DateInterval.WeekOfYear,Parameters!STARTDATE.Value,Parameters!ENDDATE.Value)*2)

-(iif(Weekday(Parameters!STARTDATE.Value) = 7,1,0)

-(iif(Weekday(Parameters!ENDDATE.Value) = 6,1,0))-1)

------------------------------------------------------

//Correct One

=(DateDiff(DateInterval.day,Fields!issuedate.Value,Fields!submitteddate.Value)-1)

-(DateDiff(DateInterval.WeekOfYear,Fields!tissuedate.Value,Fields!submitteddate.Value)*2)

+(iif(Weekday(Fields!issuedate.Value) = 7,1,0))

+(iif(Weekday(Fields!submitteddate.Value) = 1,1,0))

-(iif(Weekday(Fields!submitteddate.Value) = 7,1,0))

-(iif(Weekday(Fields!submitteddate.Value) = 1,1,0)-1)

----------------------------------------------------------------------------------

=DatePart("ww",Parameters!SalesDate.Value,IIF(year(Parameters!SalesDate.Value),vbSunday,vbSaturday))

//Give day number.

=DatePart(DateInterval.Weekday, Parameters!SalesDate.Value, FirstDayOfWeek.Sunday)