Prev: Formatting Text to Numbers for Dates
Next: organization charts
From: Ben Kelly Ben on 27 May 2010 17:51
Hi, I have a gantt chart which has columns headed by dates

A B C D E F
1 10/12 17/24 24/12 31/12 1/7
2 Do A
3 Finish B
4 Start C
5
6
7

I would like to put a formula in colum F to show the date that the action in
the row will be completed by. The real worksheet has 52 columns in it so
using an IF statement isn't an option. Each row will only have one entry in
it.

Thanks for any help

Ben
9
10



 | 
Pages: 1
Prev: Formatting Text to Numbers for Dates
Next: organization charts