1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| Function EstFerie(ByVal QuelleDate As Date) As Boolean
Dim anneeDate As Integer
Dim joursFeries(1 To 12) As Date
Dim i As Integer
anneeDate = Year(QuelleDate)
joursFeries(1) = DateSerial(anneeDate, 1, 1)
joursFeries(2) = DateSerial(anneeDate, 5, 1)
joursFeries(3) = DateSerial(anneeDate, 6, 6)
joursFeries(4) = DateSerial(anneeDate, 7, 21)
joursFeries(5) = DateSerial(anneeDate, 8, 15)
joursFeries(6) = DateSerial(anneeDate, 11, 1)
joursFeries(7) = DateSerial(anneeDate, 11, 2)
joursFeries(8) = DateSerial(anneeDate, 11, 11)
joursFeries(9) = DateSerial(anneeDate, 12, 25)
joursFeries(10) = fLundiPaques(anneeDate)
joursFeries(11) = joursFeries(10) + 38 ' Ascension = lundi de Paques + 38
joursFeries(12) = joursFeries(10) + 49 ' Lundi Pentecôte = lundi de Paques + 49
For i = 1 To 12
If QuelleDate = joursFeries(i) Then
EstFerie = True
Exit For
End If
Next
End Function |
Partager