View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mark paul mark paul is offline
external usenet poster
 
Posts: 1
Default convert date (YYYYMMDD) to weeknumber

Hello, from a database query I have production dates in format YYYYMMDD (e.g.
20070227) I would like to convert this to a weeknumber. How can I do this?

your help is very much appreciated