need some tips!

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?

Add this to first date cell and copy down

=IF(B2<>"",DATE(YEAR(TODAY()),MONTH(TODAY()),MID(CELL("filename",A1),FIND("]
",CELL("filename",A1))+1,99)),"")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"cjjoo" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

My pleasure.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cjjoo" <[email protected]> wrote in
message news:[email protected]...
>
> exactly what i needed.... tks tks
>
>
> --
> cjjoo
> ------------------------------------------------------------------------
> cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
> View this thread: http://www.excelforum.com/showthread...hreadid=476165
>

sorry but is it possble to make modification of the formula to suit this scenario?

the scenario:

vehicle_no date in date out



in your formula the date will be assigned (based on sheet no )if a vehicle_no

has been selected. in my sheets, the outstanding work in day 1 will be reflected

in day 2 (sheet 2) . So if i key in the vehicle no in day one, the date_in will be


02/10/2005 and this is not true as the vehicle is dated in on 01/10/2005.

in sheet one

vehicle no date_in date_out action taken
x123 01/10/2005 change XXX
y456 01/10/2005 01/10/2005


in sheet two,

vehicle_no date_in date_out action taken
x123 01/10/2005 change yyy
x123 02/10/2005

over here, x123 is not dated_out in sheet one , so x123 will be seen in sheet two

but if i key in x123 to update the action taken, the date in is 02/10/2005 which in

fact should be 01/10/2005

pls advise...