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(CE LL("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.


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=477423