iif expected end of statement

[Cristen]

Hello. I'm trying to use this code that omits weekend days from a date
calculation. I get an Expected: end of statement error. I am not sure what
to do. I took this code off of another post I found on this site. so I am
not too advanced at this. Thanks!

..iMin = DateDiff("d", sPrevDate, sAppDate) - _
DateDiff("ww", sPrevDate, sAppDate, vbSunday) * 2 _
IIf(Weekday(sAppdate, vbSunday)= vbSaturday, _
IIf (Weekday(sPrevDate, vbSunday) = vbSaturday, 0, 1), _
IIf (Weekday(sPrevDate, vbSunday) = vbSaturday, -1, 0))

 

[Dirk Goldgar]

Hello. I'm trying to use this code that omits weekend days from a date
calculation. I get an Expected: end of statement error. I am not sure
what
to do. I took this code off of another post I found on this site. so I am
not too advanced at this. Thanks!

.iMin = DateDiff("d", sPrevDate, sAppDate) - _
DateDiff("ww", sPrevDate, sAppDate, vbSunday) * 2 _
IIf(Weekday(sAppdate, vbSunday)= vbSaturday, _
IIf (Weekday(sPrevDate, vbSunday) = vbSaturday, 0, 1), _
IIf (Weekday(sPrevDate, vbSunday) = vbSaturday, -1, 0))

It seems to me that there should be an operator of some kind after the 2 in
this line:

 

[Cristen]

Thanks Dirk! I was hoping it was something like that!