Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=476165 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
need some tips!
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 |
#4
|
|||
|
|||
need some tips!
My pleasure.
-- HTH RP (remove nothere from the email address if mailing direct) "cjjoo" wrote in message ... 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 |
#5
|
|||
|
|||
need some tips!
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... -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=476165 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink Screen Tips not cross platform | Excel Discussion (Misc queries) | |||
Hyperlink Screen Tips in Excel | Excel Discussion (Misc queries) | |||
Free Excel Tips & Tricks Webinar.... | Excel Discussion (Misc queries) | |||
Tips and Tricks | Excel Discussion (Misc queries) | |||
Free Webinar on Excel tips & tricks by an Excel MVP | Excel Discussion (Misc queries) |