week number

[Mike B]

Hi,
Can anyone help. I am using the WEEKNUM fuction to enter the week numberin a
cell, I would like to add the numbers 1134 after the week number but in the
same cell. Is this possible,

Thanks

 

[Mike H]

Hi,

try this

=WEEKNUM(A1)&1134

Mike

 

[Rick Rothstein]

What do you mean by "add the numbers 1134 *after* the week number"? Do you
mean if the week number was 25, you want the formula to return 251134 or
1159? Also, show us your formula so we can show you want to do to it to get
your desired result.

 

[Mike B]

Thanks, it worked a treat.

Hi,

try this

=WEEKNUM(A1)&1134

Mike

 

[Mike B]

hi,
I wanted the numbers to follow the week number ie 251135, however the
quuestion has been answered, thanks for your offer of hlep anyway

Mike B