MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)