#1   Report Post  
Dave Peterson
 
Posts: n/a
Default

Maybe you could just include the date and day in A10:

Format|cells|number tab|custom
type:
dd-mmm-yy* dddd

If you expand the column width, you'll see how that "* " works.

Jeff wrote:

Hello,

I have in column "A" row "10" the date as follow: 15-Feb-05.
It is possible to get in column "B" row "10" the day of the week as follow:
Monday ?
Regards,


--

Dave Peterson
Reply
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
count weekdays in a date range benb Excel Worksheet Functions 1 January 13th 05 02:49 PM
Recognizing weekends and changing to weekdays in Excel hanauer Excel Discussion (Misc queries) 2 January 8th 05 02:13 AM
Date exclude weekdays LukePW New Users to Excel 9 December 20th 04 05:00 PM


All times are GMT +1. The time now is 06:13 PM.

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"