Counting time

  • Thread starter Thread starter Lisa
  • Start date Start date
L

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!
 
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!
Click to expand...

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

Regards
 
Back
Top