View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default I have run out of arguments for nested IF statement

You could use this type of formula:

15.03.2006 Week 12 <-- ="Week "&WEEKNUM(A1,2)

Hans