Transpose week numbers to date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thanks JE - I'll give it a go
Cheers
Lewej

JE McGimpsey said:
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.
Click to expand...
 
Back
Top