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
| Sub sc()
[B2] = DatePart("ww", 31 / 12 / 2007, vbMonday, vbFirstFourDays)
[B3] = DatePart("ww", 1 / 1 / 2008, vbMonday, vbFirstFourDays)
[C2] = DatePart("ww", #12/31/2007#, vbMonday, vbFirstFourDays)
[C3] = DatePart("ww", #1/1/2008#, vbMonday, vbFirstFourDays)
[D2] = DatePart("ww", CDate("31/12/2007"), vbMonday, vbFirstFourDays)
[D3] = DatePart("ww", CDate("01/01/2008"), vbMonday, vbFirstFourDays)
[E2] = DatePart("ww", DateSerial(2007, 12, 31), vbMonday, vbFirstFourDays)
[E3] = DatePart("ww", DateSerial(2008, 1, 1), vbMonday, vbFirstFourDays)
[F2] = NOSEM(DateSerial(2007, 12, 31))
[F3] = NOSEM(DateSerial(2008, 1, 1))
End Sub
Function NOSEM(D As Date) As Long
D = Int(D)
NOSEM = DateSerial(Year(D + (8 - Weekday(D)) Mod 7 - 3), 1, 1)
NOSEM = ((D - NOSEM - 3 + (Weekday(NOSEM) + 1) Mod 7)) \ 7 + 1
End Function |
Partager