Hi there

I would be grateful for your help

I will explain but if you could see below firstly......

COLUMN AJ INTERNAL WORK COLUMN AV EXTERNAL WORKS COLUMN AX OVERALL COMPLETED


column aj (1) 12/12/06
column av(1) (BLANK)
column ax (1) (LEAVE IT BLANK)

column aj (2) 12/12/06
column av (2) N/A
column ax (2) 12/12/06

column aj (3) (BLANK)
column av (3) (BLANK)
column ax (3) (LEAVE IT BLANK)

column aj (4) N/A
column av (4) 12/06/06
column ax (4) 12/06/06

column aj (5) 12/12/06
column av (5) 15/12/06
column ax (5) 15/12/06

ok here we go.....

in this project that im currently on ...i need to set up formulas/function that on the column ax,(1) internal works a date has been input but not in the external works then in the overall completed should leave it a blank..

if in line 4) internal works input n/a and the external works has date input then in the overall completed should have the date as 12/06/06



But if both internal works and external works has been completed, then in the overall completed need to look for the last date input e.g line 5) 15/12/06.......make any sense to what im' trying to explain?


Thanks

Craig