Thread: How to format a cell from date to week?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nginhong nginhong is offline
external usenet poster
  
Posts: 15
Default How to format a cell from date to week?
Dear all,

How to format a cell date like "2009-12-10" to year /week format "YYYYWW" =
200950?
Also how to determine number of weeks between 2 weeks like from 200950 to
201002 = 5 weeks?

BR//nginhong
Reply With QuoteReply With Quote