How can I convert this number into a week#
 

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!!

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

"msbutton27" wrote:

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!!

See response in .worksheetfunctions

--

HTH

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


"msbutton27" wrote in message
...
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

"msbutton27" wrote:

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!!