the problem:

in my workbook , i got 30 sheets and they are name 1 to 30 ( for each day of the month)

the format of each sheets are similar and it looks like this:

sheet 1:
vehicle no date_in date_out action taken
x123 01/10/2005 change xxx
y456 01/10/2005 change yyy
z789 01/10/2005 01/10/2005 change zzz

sheet 2

x123 01/10/2005 change aaa
y456 01/10/2005 change bbb



in sheet 2, only x123 and y456 is shown (auto) since there is no
date_out in sheet 1.

and the date_in is given once a vehicle_no is issued. The formula is :

IF(A2<>"",DATE(YEAR(TODAY()),MONTH(TODAY()),MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,99)),""))


so my question is :

it is possible for x123 to be assign again but it will return the date in

as 01/10/2005 instead of 02/10/2005 since it it an old job and not a new one? i hope it can be done by modifying the

above formula.

pls advise.