How can I convert this number into a week#

[msbutton27]

Hello,

I am trying to determine if it is possible to convert a 6 digit number into
a week - for example:
050525 = yymmdd = 2005, May 25th
and I want my field to determine what the week number of the year is...

This week is week 21, therefore based on my entry of the date format above I
want the week column autofilled...

Is this possible?

Thanks - Have a Good One!!

 

[msbutton27]

I also forgot one thing - the number that I have in my first column is
actually like this:

yymmdd-<5 digit random#>

Therefore I also need to know how I can parse the first 6 digits and ignore
the rest of the -<5 digit random#>

.....Mike

 

[Bob Phillips]

See response in .worksheetfunctions

--

HTH

RP
(remove nothere from the email address if mailing direct)