hello my dear friend, thank you very much for your quick reply. I will try.
with best regards.
m.chandru
----- Original Message -----
From: "Amiyo Biswas" <[EMAIL PROTECTED]>
To: <accessindia@accessindia.org.in>
Sent: Sunday, October 12, 2008 1:29 PM
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