| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Transpose week numbers to date
Hi
One of my users would like to have certain cells in his spreadsheet, where if you type a week number it will transpose it to a date. For example 01 might be 01/04/2005, 02 might be 08/04/2005 and 52 might be 25/03/2006. I am clueless on this one, and not very good at Excel anyhow Thanks in advacne Harry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formula to recognize day of the week from date | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| extract numbers, convert to date | Excel Discussion (Misc queries) | |||
| Week Numbers | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Threaded Mode
