Weird date format connected to week number
Posted by Riikka on June 08, 2001 12:02 AM
I have a problem concerning the date format which shows as 04Jun2001000000 (ddmmmyyyyhhmmss). I need to get the corresponding week number (eg W232001). How is this possible? The function WEEKNUM("4/6/01", 2) is not of great help!
Posted by Mark W. on June 08, 2001 7:26 AM
WEEKNUM() needs a date value (e.g., 37046) as its
1st argument. You can coerce a text representation
of a date by adding 0 to it; therefore, try...
=WEEKNUM("6/4/2001"+0,2)
