Hello Amiyo, I'm also using office 2002 and it is working well here. In case of 10/28/2008, it does show "Tuesday"
Regards, Chetan Sharma ----- Original Message ----- From: "Amiyo Biswas" <[EMAIL PROTECTED]> To: <accessindia@accessindia.org.in> Sent: Wednesday, October 15, 2008 1:47 PM 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 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
