| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date format and day of week | Setting up and Configuration of Excel | |||
| Date format with day of week and date | Excel Discussion (Misc queries) | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) | |||
| Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) | |||
Threaded Mode
