| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert date (YYYYMMDD) to weeknumber
=WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)))
Bur if you need ISO week numbers, read this first http://www.cpearson.com/excel/weeknum.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "mark paul" <mark wrote in message ... | 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate a date based on a weeknumber | Excel Discussion (Misc queries) | |||
| Calculate a date based on a weeknumber | Excel Worksheet Functions | |||
| How do I convert 'YYYYMMDD to an age in Excel? | New Users to Excel | |||
| I need a yyyymmdd date format with no dashes | Excel Discussion (Misc queries) | |||
| Is there an Excel date format as follows: yyyymmdd? | Excel Discussion (Misc queries) | |||
Linear Mode
