Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I need your help
I have to count the difference between two dates without counting the sundays
Any idea please ?
Thanks
May be look here:
i see that the solution is to create a function, how to do that please?
Thanks
Function is give by Gysbert in that link
Function GetWorkDays(StartDate, EndDate)
dCount = 0
For dt = StartDate To EndDate
If WeekDay(dt) <> 1 Then
dCount = dCount + 1
End If
Next
GetWorkDays = dCount
End Function
Use SET on top, something like this
below example is Not your case:
SET MonthDiff = Num(((year($2) * 12) + month($2)) - (((year($1) * 12) + month($1))) + 1);