Add this to first date cell and copy down
=IF(B2<"",DATE(YEAR(TODAY()),MONTH(TODAY()),MID(C ELL("filename",A1),FIND("]
",CELL("filename",A1))+1,99)),"")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"cjjoo" wrote in
message ...
this is my problem:
i got worksheets number from 1-30 (days of the month) and in each
worksheet
the formats are the same. The format look something like this:
unique ID vehicle no date in date out status
in date in,i want to have a formula that automatically insert the date
when i key
in a vehicle num . The date in will also be the same as the sheet no,
so can i use
a indirect formula to return the date?
--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=476165