1
2
3
A
Date
19-Feb-2007
3-Jan-2008
Formula Description (Result)
=TEXT(A2, "dddd") Calculates the day of the week for the date and
returns the full name of the day of the week (Monday)
=TEXT(A3, "ddd") Calculates the day of the week for the date and
returns the abbreviated name of the day of the week (Thu)
----- Original Message -----
From: Mayank Patel
To: excel-macros@googlegroups.com
Sent: Tuesday, October 14, 2008 10:21 AM
Subject: $$Excel-Macros$$ Can I get Day from date in excel.
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
-~----------~----~----~----~------~----~------~--~---
