Search results

I have a simple function: Public Function DayY(ByRef Var1 As Variant, _ ByRef Var2 As Variant) As String Dim nDayY As String If IsNull(Var1) And Var2 = "Yes" Then nDayY = "Yes" Else nDayY = "No" End If DayY = nDayY End Function...

I know tha this is basic but I can't figure it out as I am a novice. I am trying to get some code so that when I I just Put expr1: Func() into a field it will come back with the needed result. I have come up with: Public Function Func() As String Dim temp As String Dim var1 As...

I'm trying to work out the number of working days between 2 days (eg 01/05/2013 & today). I found the following code: ' Weekdays Function Public Function Weekdays(ByRef startDate As Date, _ ByRef endDate As Date _ ) As Integer ' Returns the number of weekdays in the period from...