N° of the week from a date
|
11-01-2015, 06:15 PM
Post: #1
|
|||
|
|||
N° of the week from a date
HI,
Here is an another little, sometime usefull to know in which week will occur an evenement. Th formulae is : N° week= IP[DOW(1/1/YYYY)+DOY(JJ,MMYYYY)+5]/7 - [IP(DOW(1/1/YYYY)/5]. Code:
It is according to ISO 8601, so for old calendars the result may vari +/- 1 week. 17/04/1982----> 15 (week 15) 30/06/1950----> 26 (week 26) Gérard. Gérard. |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: 3 Guest(s)