Counting time

[Lisa]

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!

 

[vsoler]

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

 

[Lisa]

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