Excel XP - convert number to a date

[mandypen]

Hi,

Firstly let me say that I'm not even sure if this is possible!

I have 2 columns of numbers, I have the formula to divide one column by
another to produce a whole number:

=ROUNDUP((A2/B2),0)

this is fine. The number produced as a resut of this is displayed in
column 3 and this number is a week number (where the week number is the
first Monday in every month). In a 4th column, I would like to have the
week number displayed as a date. For example:

1 would be 6 January 2003
2 would be 13 January 2003
3 would be 20 January 2003

right through to:-

52 would be 29 December 2003

I had thought that I could do a very large nested 'if' statement but I
now find that Excel will only allow a maximum of 7 nested 'ifs'. If
anyone knows of a way to do this I'd be very grateful - or
alternatively if anyone knows that there is no earthly way this is
possible - please let me know,

Thanks!

 

[Ken Wright]

Assuming your year start date, eg 01/01/2003 is in A1, and your week numbers are in Col C starting
C1, then the following in D1 copied down, will give you what you want:-

=$A$1-2+(C1*7) formatted as dates

Depending on the year you choose, you may have to adjust the 2, to ensure you get the mondays.