Nested Formula - HELP
Hi Gayla,
try this array formula on cell K5.
IF(AND($I5="",$J5="",AND(SUM(IF($G5:$H5=k$3,1))= 1,SUM(IF($G5:$H5<=k$2,1))=1)),1,IF(AND($I5<"",$J 5<"",AND(SUM(IF($I5:$J5=k$3,1))=1,SUM(IF($I5:$J 5<=k$2,1))=1)),1,""))
copy the above line to cell k5, type "=" , then press ctrl+shift+enter.
then
copy K5 until BJ5,
then
you can copy K5:BJ5 downward for another set of schedule..
Note: row 3 and row 2, contains the common reference for start and finish
assumption:
In columns K thru BJ I have two sets of dates (two sets per column) that
represent one week based off the yearly calender, for example:
K3 - 01/01/07, K2 - 01/07/07
L3 - 01/08/07, L2 - 01/14/07
IF((AND($I$5="",$J$5="")
I have four columns where I could enter two sets of dates, planned and
actual. Prior to the project starting I will enter dates into G and H (I and
J will be blank at this time), once the project starts I will fill in the
dates into columns I and J.
G - Planned Start
H - Planned End
I - Actual Start
J - Actual End
looking for your success...
regards,
driller
--
*****
birds of the same feather flock together..
|