Instead of using the nested IF function which makes the formula quite complicated, you can just use the weekday and custom format your cell as DDDD and get the desired result. Or as Dev suggested, Text(A1, "DDDD") works just as fine.
Anil From: excel-macros@googlegroups.com [mailto:[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 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 -~----------~----~----~----~------~----~------~--~---
