sdawson
Registered User.
- Local time
- Today, 11:43
- Joined
- Apr 22, 2003
- Messages
- 165
Does anyone have code that will calculate the week of the year as per ISO8601?
viz. If there are less than 4 days in January in the new year then this is not week 1 it is week 52 or possibly week 53 of the previous year.
=Format(Now(), "ww") is displayed as week 1 even if there is only one day of January in it.
This is for the week Monday to Sunday.
Help.
viz. If there are less than 4 days in January in the new year then this is not week 1 it is week 52 or possibly week 53 of the previous year.
=Format(Now(), "ww") is displayed as week 1 even if there is only one day of January in it.
This is for the week Monday to Sunday.
Help.
