Thread: week number
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike B Mike B is offline
external usenet poster
  
Posts: 55
Default week number
Thanks, it worked a treat.


"Mike H" wrote:

Hi,

try this

=WEEKNUM(A1)&1134

Mike

"Mike B" wrote:

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
Reply With QuoteReply With Quote