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,"DDDD") 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 On 10/14/08, 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 -~----------~----~----~----~------~----~------~--~---
