Function ConstSunday(MyDate, CurDay)
Dim Sunday(4), ArrSunday, item, iitem
ConstSunday = False
Sunday(0) = "1:1" ' ### Nyårsdagen
Sunday(1) = "1:6" ' ### Trettondedag Jul
Sunday(2) = Midsommar(CurDay) ' ### Midsommar
Sunday(3) = "12:25" ' ### Juldagen
Sunday(4) = "12:26" ' ### Annandag Jul
For item = 0 To UBound(Sunday)
ArrSunday = Split(Sunday(item), ":")
[red][b]line 103[/b] If Int(Month(MyDate)) = Int(ArrSunday(0)) Then[/red]
For iitem = CurDay To 31
If Day(CurDay) = Day(ArrSunday(1)) Then
ConstSunday = True
Exit For
End If
Next
End If
If ConstSunday = True Then Exit For
Next
End Function
Private Function Midsommar(CurDay)
If Month(MyDate) = 6 Then
If Int(CurDay) > 19 And Int(CurDay) < 27 Then
For item = 20 To 27
If WeekDay(CDate(Year(MyDate)&"-06"&item), vbMonday) = 6 Then
Midsommar = "6:" & item
Exit For
End If
Next
End If
End If
End Function
Private Function ConstSunday(MyDate, CurDay)
Dim Sunday(4), ArrSunday, item, iitem
ConstSunday = False
Sunday(0) = "1:1" ' ### Nyårsdagen
Sunday(1) = "1:6" ' ### Trettondedag Jul
Sunday(2) = Midsommar(CurDay) ' ### Midsommar
Sunday(3) = "12:25" ' ### Juldagen
Sunday(4) = "12:26" ' ### Annandag Jul
For item = 0 To UBound(Sunday)
ArrSunday = Split(Sunday(item), ":")
If Month(Month(MyDate)) = Month(ArrSunday(0)) Then
For iitem = CurDay To 31
If Day(CurDay) = Day(ArrSunday(1)) Then
ConstSunday = True
Exit For
End If
Next
End If
If ConstSunday = True Then Exit For
Next
End Function
Private Function Midsommar(CurDay)
Dim item
For item = 20 To 27
If WeekDay(CDate(Year(MyDate)&"-06-"&item), vbMonday) = 6 Then
Midsommar = "6:" & item
Exit For
End If
Next
End Function