Counting time
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
|