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 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
'calcule le jour de Pâques et les fêtes mobiles
'(calendrier depuis 1900 uniquement)
Public Function FeteFerie(ByVal Annee As Integer, TypeFerie As Integer)
Dim Paques As Date
Dim LunPaq As Date
Dim Ascension As Date
Dim LunPent As Date
Paques = fPaques(Annee) 'Cherche le jour de Pâques
LunPaq = Paques + 1 'En déduit
Ascension = Paques + 39 'les autres
LunPent = Paques + 50 'jours fériés
Select Case TypeFerie
Case 1
FeteFerie = DateSerial(Annee, 1, 1)
Case 2
FeteFerie = DateSerial(Annee, 5, 1)
Case 3
FeteFerie = DateSerial(Annee, 7, 21)
Case 4
FeteFerie = DateSerial(Annee, 8, 15)
Case 5
FeteFerie = DateSerial(Annee, 11, 1)
Case 6
FeteFerie = DateSerial(Annee, 11, 11)
Case 7
FeteFerie = DateSerial(Annee, 12, 25)
Case 8
FeteFerie = Paques
Case 9
FeteFerie = Ascension
Case 10
FeteFerie = LunPent
Case Else
FeteFerie = DateSerial(Annee, 1, 1)
End Select
End Function |
Partager