Hello,

I have a table with 'time to event' in column B - i.e 20 weeks (doesn't have
to be weeks)
In column C i would like to calculate the actual DATE from information in
col B.

Assume i have put the date of event in A1 as 25/12/08
So above example should provide answer of 7/08/08
help!

On Jul 31, 7:24*am, Lisa wrote:
Hello,

I have a table with 'time to event' in column B - i.e 20 weeks (doesn't have
to be weeks)
In column C i would like to calculate the actual DATE from information in
col B.

Assume i have put the date of event in A1 as 25/12/08
So above example should provide answer of 7/08/08
help!

Use in C1: =A1+B1*7 format the result as a date

Regards

Excel measures dates in units of 1 day, so =A12-(20*7) and format as date.
--
David Biddulph

"Lisa" wrote in message
...
Hello,

I have a table with 'time to event' in column B - i.e 20 weeks (doesn't
have
to be weeks)
In column C i would like to calculate the actual DATE from information in
col B.

Assume i have put the date of event in A1 as 25/12/08
So above example should provide answer of 7/08/08
help!

Ah, easy! i should have worked that one out myself
thank you

"David Biddulph" wrote:

Excel measures dates in units of 1 day, so =A12-(20*7) and format as date.
--
David Biddulph

"Lisa" wrote in message
...
Hello,

I have a table with 'time to event' in column B - i.e 20 weeks (doesn't
have
to be weeks)
In column C i would like to calculate the actual DATE from information in
col B.

Assume i have put the date of event in A1 as 25/12/08
So above example should provide answer of 7/08/08
help!