1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Private Sub Command1_Click()
Dim mesmois()
datedeb = "16/01/2008"
datefin = "25/01/2008"
nbmois = Month(datefin) - Month(datedeb)
ReDim mesmois(nbmois)
For i = 0 To nbmois
If nbmois = 0 Then
mesmois(i) = Day(datefin) - Day(datedeb)
ElseIf i = 0 Then
mesmois(i) = Day(DateSerial(Year(datedeb), Month(datedeb) + i + 1, 0)) - Day(datedeb)
ElseIf i < nbmois Then
mesmois(i) = Day(DateSerial(Year(datedeb), Month(datedeb) + i + 1, 1) - 1)
Else
mesmois(i) = Day(datefin)
End If
MsgBox "mois " & i + 1 & "===>>>" & mesmois(i) & " jours"
Next
End Sub |