LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Getting weekday for a date


hi,

In one of my cells i want to display the weekday corresponding to a
specific date.

For example i want to display "Monday" if the date i am referring (from
another cell) as being the 05/09/2005 (5th Sept 2005).

How do I achieve this?

Cheers

Sahil


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=400688

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to compute date of next weekday? [email protected] Excel Discussion (Misc queries) 4 July 31st 08 02:05 AM
calculating weekday date Khardy3352 New Users to Excel 3 June 11th 08 11:27 AM
convert weekday date to the next sunday date Oldersox Excel Worksheet Functions 2 January 8th 07 11:26 AM
WEEKDAY() function: display TEXT not numeric weekday tom Excel Discussion (Misc queries) 3 November 21st 06 04:32 PM
MATCHING DATE TO A WEEKDAY Stuart Carnachan Excel Worksheet Functions 3 October 31st 06 05:19 PM


All times are GMT +1. The time now is 12:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"