Look at this link
http://www.mrexcel.com/archive/Dates/29314.html
this s workin fine
9-Oct-2008 Wednesday 10-Oct-2008 Thursday 11-Oct-2008 Friday 13-Oct-2008
Sunday
On Mon, Oct 13, 2008 at 11:51 PM, Mayank Patel <[EMAIL PROTECTED]> wrote:
> Hi friends,
> Is there any worksheet function to
HI Mayank,
You can use the following:
=TEXT(A1,"") - For Day
=TEXT(A1,"") - For Month
=TEXT(A1,"") - FOr Year
make sure it is the MM/DD/YY format.
Thanks,
Dharmesh
On 10/14/08, Mayank Patel <[EMAIL PROTECTED]> wrote:
>
> Hi friends,
> Is there any worksheet function to get the da
Hi Friend,
Use Weekday function for getting the Day number of the week.
Create a table with Week No's and Week Day Names.
Use Vlookup for picking the WeekDay name from It.
Find the Excel sheet attached for your reference.
Have a nice day.
Regards
Rahul Vegesna
On Tue, Oct 14,
om [mailto:
> [EMAIL PROTECTED] *On Behalf Of *muralidhar rao
> *Sent:* Tuesday, October 14, 2008 6:07 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Can I get Day from date in excel.
>
>
>
> u can try using the Day() function, but do remember to s
THis is the best way I guess short and simple!!
On Tue, Oct 14, 2008 at 10:27 PM, nvdev <[EMAIL PROTECTED]> wrote:
> Yes, use =Text(A1,"DDD") would return the day.
> -Dev
>
> On Mon, Oct 13, 2008 at 11:51 PM, Mayank Patel <[EMAIL PROTECTED]> wrote:
>
>> Hi friends,
>> Is there any worksheet fun
ted by Shivkumar. I really appreciates
shivkumar's help..
Regards,
Sarfaraz Ahmed
http://findsarfaraz.blogspot.com
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of N.Shivkumar
Sent: Tuesday, October 14, 2008 2:29 PM
To: excel-macros@googlegroups.com; [EMAI
, October 14, 2008 6:07 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Can I get Day from date in excel.
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, Oc
lto:[EMAIL PROTECTED]
On Behalf Of Ajay Varshney
Sent: Tuesday, October 14, 2008 4:42 PM
To: excel-macros@googlegroups.com; [EMAIL PROTECTED]
Subject: $$Excel-Macros$$ Re: Can I get Day from date in excel.
you can use the formula which is mentioned in the attached file.
On Tue, Oct 14, 2008 a
Yes, Mayank
There is a formula called: Text
Wherein A1 cell contains date and if u wanna give result in b1 cell then
type:
=TEXT(a1,"") You will get day of that particular date
Hope, it will help u. And if u still face difficulties, contact me without
any hesitations.
Regards,
Sanjaykumar
Dear Mayank,
type date and goto format cell, custom and type -
thanks
sudhir
09818890317
- Original Message -
From: Mayank Patel
To: excel-macros@googlegroups.com
Sent: Tuesday, October 14, 2008 10:21 AM
Subject: $$Excel-Macros$$ Can I get Day from date in excel.
Weekday(date) will return a number corresponding to the day of week.
Formatting the cell to '' will show the day of week as text
HTH
Tim Mills-Groninger
On Oct 13, 11:51 pm, "Mayank Patel" <[EMAIL PROTECTED]> wrote:
> Hi friends,
> Is there any worksheet function to get the day like Monday
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
>
> >
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]
you can use the formula which is mentioned in the attached file.
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
>
> >
>
--~-
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 w
Yes, you could. Use =TEXT(A1, "DDD") where A1 referes to the cell.
-Dev
On Oct 13, 11:51 pm, "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
--~--~-~-
=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.
H
Also to perform in-place conversion, you can use the Cell Format Custom
"".
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.
>
> Rega
Hi,
If your date is in A1, then format A2: Format > Special,
Then in A2 enter: =A1
Regards - Dave.
Date: Tue, 14 Oct 2008 10:21:35 +0530
From: [EMAIL PROTECTED]
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Can I get Day from date in excel.
Hi friends,
Is there any worksheet
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 th
Yes, use =Text(A1,"DDD") would return the day.
-Dev
On Mon, Oct 13, 2008 at 11:51 PM, 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
>
> >
>
--
Thanks,
Dev
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,
22 matches
Mail list logo
