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 -~----------~----~----~----~------~----~------~--~---
