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 |
#2
|
|||
|
|||
One way:
Assume the week number is input into cell A1: B1: =DATE(2005,4,1) + 7 * (A1-1) Format the cell as a date. Note that I get 24/03/2006 rather than 25/03/2006 for A1=52. In article , "Lewej" wrote: 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 |
#3
|
|||
|
|||
Thanks JE - I'll give it a go
Cheers Lewej "JE McGimpsey" wrote: One way: Assume the week number is input into cell A1: B1: =DATE(2005,4,1) + 7 * (A1-1) Format the cell as a date. Note that I get 24/03/2006 rather than 25/03/2006 for A1=52. In article , "Lewej" wrote: 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 |
Reply |
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) |