Thread: How to display weeknumber with year code
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default How to display weeknumber with year code
=TEXT(A1,"yy")&TEXT(weeknum(A1),"00")

--

HTH

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


"Lubo" wrote in message
...
I can display weeknumber but I need in front year code in 2 cifers.
Does anyone knows easy solution?


Reply With QuoteReply With Quote