Hello,
I am enclosing the similar formula and UDF. Use anything you like
=LOOKUP(WEEKDAY(B5),
{1,2,3,4,5,6,7},{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday"
,"Saturday"})
Its similar to the formula pasted 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; [EMAIL PROTECTED]
Subject: $$Excel-Macros$$ Re: Can I get Day from date in excel.
Dear Friend
You can use the function as under :
=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Frid
ay","Saturday")
Where A1 is the date that you enter
N.Shivkumar
Office : +914027685423
Mobile : +919866533180
Res : +914040035774
Alternate Email : [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
day.xls
Description: MS-Excel spreadsheet
