WeekDateISO ( date )
Rate this function: Average rating: 3.1 (17 votes)
Discuss this Custom Function
Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net
Returns date in extended ISO 8601 week date format.
Sample Input:
|
Sample Output:
|
Description:
Returns date in extended ISO 8601 week date format.
The International Standard ISO 8601 extended format representation of week dates is yyyy-Www-d, where W is the actual letter "W", ww refers to the two digit week number, and d is the day's number.
Weeks are represented by two digits beginning with 01 being the first week of the year, up to 52 or 53 being the last week of the year. The first week of a year is the first week that contains four or more days of that year. Weeks start with Monday.
Days are represented by a single digit beginning with 1 being Monday, ending with 7 being Sunday.
This function is not recursive.
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:
|
Newest Custom Functions:
| 1. |
list.intersect (listA; listB) |
| |
(Mon, May 14, 12:43pm) |
| 2. |
WeekStart ( weekOfYear ; year ) |
| |
(Sat, May 12, 8:42am) |
| 3. |
PercentToWords (FIELD) |
| |
(Thu, May 10, 3:16pm) |
| 4. |
PercentToText (FIELD) |
| |
(Thu, May 10, 2:37pm) |
| 5. |
StripReserved( text ) |
| |
(Wed, May 02, 6:05pm) |
| 6. |
ListBaseTables |
| |
(Wed, May 02, 3:48pm) |
| 7. |
ValidEmail( theEmail ) |
| |
(Wed, May 02, 7:27am) |
| 8. |
UltraDate (Text; LongDate_or_DateDigit) |
| |
(Wed, May 02, 6:07am) |
 |
|
Hi Michael,
what a nice function! I don't dare giving you my previous calculation, it was such a mess compared to yours.
I'm now looking for the reverse function : give a ISO week number and year, and get a date (or a list of dates).
If by chance you have such a thing ready...
Many thanks,
Fabrice
Fabrice Nordmann, Brussels
December 02, 2010 6:04am