Hi all, It should be "Weekday", not "Day" function as Maddy as suggested, I suppose. The day function returns the day of the month, not of the week.
Regards Anil From: excel-macros@googlegroups.com [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 set the format of the cell to "dddd 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, 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, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
