No, amiyo, in fact, it does not work for me on any date in office 2003. Thanks
Rajesh -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amiyo Biswas Sent: Wednesday, October 15, 2008 1:48 PM To: accessindia@accessindia.org.in Subject: Re: [AI] I need your guidance Hello, I am still using office 2002. Maybe somebody on the list will come up with the solution. Still why should it not work on this date if it works on other dates? Best regards, Amiyo Biswas. Cell: +91-9433464329 ----- Original Message ----- From: "vinod benjamin" <[EMAIL PROTECTED]> To: <accessindia@accessindia.org.in> Sent: Tuesday, October 14, 2008 10:40 PM Subject: Re: [AI] I need your guidance > Dear sir, > > Its not working to me the date displays the same, and I am using ms office > 2003, > > When I mark 10/28/08 the result is 10/28/08. > > Thanks and Regards, > > Vinod Benjamin, > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Amiyo Biswas > Sent: Monday, 13 October, 2008 12:15 PM > To: accessindia@accessindia.org.in > Subject: Re: [AI] I need your guidance > > Hello Benjamin, > > I have just tested the date 10/28/08 and it's showing Tuesday. Try it once > more. Remember that the formula is just =a1 which actually displays the data > in cell a1. The only trick is in the format "dddd" (4 d) which displays only > the day. > > Best regards, > > Amiyo Biswas. > > Cell: +91-9433464329 > > ----- Original Message ----- > From: "vinod benjamin" <[EMAIL PROTECTED]> > To: <accessindia@accessindia.org.in> > Sent: Sunday, October 12, 2008 11:03 PM > Subject: Re: [AI] I need your guidance > > > > Dear sir, > > > > It's a great formula thanks for it, but its ok for sertain dates but in > > case if its like 10/28/08 its not working, can youHelp? > > > > Thanks and Regards, > > > > Vinod Benjamin, > > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Amiyo Biswas > > Sent: Sunday, 12 October, 2008 1:29 PM > > To: accessindia@accessindia.org.in > > Subject: Re: [AI] I need your guidance > > > > Hello, > > > > You can achieve it in excel by simple use of format. > > 1. First, enter the date in mm/dd/yyyy format in a cell, say cell A1. You > > can use other formats, but then you will need extra work. > > > > 2. Go to another cell, suppose cell B1 and press the equal key to enter > the > > formula "A1". > > > > ?. With cell B1 selected, go to Format menu, cells submenu, number tab, > and > > arrow down to Customs format. > > > > 4. Tab over to the edit field and enter "dddd" without the quotes, and > > activate the ok button. > > > > Now if you enter 3/6/1906 in cell A1, B1 will display Tuesday. If you > enter > > 6/3/1906, it will show Sunday. > > > > Did you ask for it at all? I am not sure. > > > > Best regards, > > Amiyo Biswas. > > Cell: +91-9433464329 > > ----- Original Message ----- > > From: "M. Chandra Shekar" <[EMAIL PROTECTED]> > > To: <accessindia@accessindia.org.in> > > Sent: Saturday, October 11, 2008 10:42 PM > > Subject: [AI] I need your guidance > > > > > > > hi friends, could you please anyone guide me how to see the date and > which > > > > > day it falls in computer e.g. 06.03.1906 this date falls on which day > > > exactly. please tell the procedure step by step. thanks in advance. > > > regards. m.chandru > > > To unsubscribe send a message to [EMAIL PROTECTED] > > > with the subject unsubscribe. > > > > > > To change your subscription to digest mode or make any other changes, > > > please visit the list home page at > > > > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > > > > > > To unsubscribe send a message to [EMAIL PROTECTED] > with > > the subject unsubscribe. > > > > To change your subscription to digest mode or make any other changes, > please > > visit the list home page at > > > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > > > > To unsubscribe send a message to [EMAIL PROTECTED] > with the subject unsubscribe. > > > > To change your subscription to digest mode or make any other changes, > please visit the list home page at > > > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > To unsubscribe send a message to [EMAIL PROTECTED] with > the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Notice: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this email by error, please notify us by return e-mail or telephone and immediately and permanently delete the message and any attachments. The recipient should check this email and any attachments for the presence of viruses. The Bank accepts no liability for any damage caused by any virus transmitted by this email. To unsubscribe send a message to [EMAIL PROTECTED] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in