Hi friends,
Is there any worksheet function to get the day like Monday, Tuesday
etc. from any given date in excel.
Regards
Mayank
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group,
u can try using the Day() function, but do remember to set the format of the
cell to dd inordeer to get the name of the day
Regards,
Maddy
On Tue, Oct 14, 2008 at 10:21 AM, Mayank Patel [EMAIL PROTECTED] wrote:
Hi friends,
Is there any worksheet function to get the day like Monday,
Sachin,
There are numerous tutorials available online. Here are the details
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
http://www.anthony-vba.kefra.com/vba/vbabasic2.htm
And MSDN has valuable collections of code snippets.
Hope this helps.
Thank you,
Dev
On Oct 14, 3:16 am, sachin
Put in Cell A1 10/14/2008 (ie 14th Oct 08) and put in Cell A2
=TEXT(A1,)... you should get Tuesday which is the actual day for
this date 14th Oct.
~ Njoi ~
On Tue, Oct 14, 2008 at 12:51 AM, Mayank Patel [EMAIL PROTECTED] wrote:
Hi friends,
Is there any worksheet function to get the day
1
2
3
A
Date
19-Feb-2007
3-Jan-2008
Formula Description (Result)
=TEXT(A2, ) Calculates the day of the week for the date and
returns the full name of the day of the
=TEXT(A1,ddd)
This will give u the day
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of Mayank Patel
Sent: 14 October 2008 10:22 am
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Can I get Day from date in excel.
Hi
Use the following worksheet function...
=TEXT(A1,)
regards,
Ajit
On Tue, Oct 14, 2008 at 10:21 AM, Mayank Patel [EMAIL PROTECTED] wrote:
Hi friends,
Is there any worksheet function to get the day like Monday, Tuesday
etc. from any given date in excel.
Regards
Mayank
--
Thank
Dear Friend
You can use the function as under :
=CHOOSE(WEEKDAY(A1),Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday)
Where A1 is the date that you enter
N.Shivkumar
Office : +914027685423
Mobile : +919866533180
Res : +914040035774
Alternate Email : [EMAIL PROTECTED]