1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
Do while DateDiff("d", Deb, Fin) >= 0
if WeekDay(Deb, vbMonday) = 1 then
NbChomes = NbChomes + 1
elseif WeekDay(Deb, vbMonday) = 2 then
NbChomes = NbChomes + 1
elseif WeekDay(Deb, vbMonday) = 3 then
NbChomes = NbChomes + 1
elseif WeekDay(Deb, vbMonday) = 4 then
NbChomes = NbChomes + 1
elseif WeekDay(Deb, vbMonday) = 5 then
NbChomes = NbChomes + 1
elseif WeekDay(Deb, vbMonday) = 6 then
NbChomes = NbChomes + 1
elseif WeekDay(Deb, vbMonday) = 7 then
NbChomes = NbChomes + 1
elseif IsFerie(Deb) then 'and WeekDay(Deb, vbMonday) <> 6 and WeekDay(Deb, vbMonday) <> 7 then
NbFeries = NbFeries + 1
else
NbOuvres = NbOuvres + 1
end if
Deb = DateAdd("d", 1, Deb)
Loop |
Partager