Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 12th 05, 05:07 PM
HT
 
Posts: n/a
Default Want day of the week when I insert a date

**cross post from microsoft.public.excel**..no answer as of yet

Excel 2003
WindowsXP

I am creating a spreadsheet and inserting many dates. I want to insert the
date and have the day of the week of that particular date appear. Otherwise
I would have to look up years worth of dates.

Is there a way to do this?

Thank you.




  #2   Report Post  
Old October 12th 05, 05:20 PM
Ron de Bruin
 
Posts: n/a
Default

Hi

Format the cells like this
dddd

--
Regards Ron de Bruin
http://www.rondebruin.nl


"HT" wrote in message ...
**cross post from microsoft.public.excel**..no answer as of yet

Excel 2003
WindowsXP

I am creating a spreadsheet and inserting many dates. I want to insert the
date and have the day of the week of that particular date appear. Otherwise
I would have to look up years worth of dates.

Is there a way to do this?

Thank you.





  #3   Report Post  
Old October 12th 05, 11:35 PM
bigwheel
 
Posts: n/a
Default

Hi, =TEXT(A1, "dddd") if your date is in A1

"HT" wrote:

**cross post from microsoft.public.excel**..no answer as of yet

Excel 2003
WindowsXP

I am creating a spreadsheet and inserting many dates. I want to insert the
date and have the day of the week of that particular date appear. Otherwise
I would have to look up years worth of dates.

Is there a way to do this?

Thank you.




  #4   Report Post  
Old October 12th 05, 11:49 PM
HT
 
Posts: n/a
Default

Thanks guys..another user said to use Format, Cell, Number, Date and click
on the second option that includes the day with the date.

"bigwheel" wrote in message
...
Hi, =TEXT(A1, "dddd") if your date is in A1

"HT" wrote:

**cross post from microsoft.public.excel**..no answer as of yet

Excel 2003
WindowsXP

I am creating a spreadsheet and inserting many dates. I want to insert

the
date and have the day of the week of that particular date appear.

Otherwise
I would have to look up years worth of dates.

Is there a way to do this?

Thank you.






  #5   Report Post  
Old October 13th 05, 11:23 AM
Thiem
 
Posts: n/a
Default


12/05/06 =WEEKDAY(A2,1) =VLOOKUP(B2,$A$11:$B$17,2,FALSE)

13/10/05 =WEEKDAY(A4,1) =VLOOKUP(B4,$A$11:$B$17,2,FALSE)

12/05/04 =WEEKDAY(A6,1) =VLOOKUP(B6,$A$11:$B$17,2,FALSE)




2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
1 Sunday



First read the Weekday Fuction to understand, If you start your week on
a Sunday, the ref to enter will be 1, meaning 1 will be first day of the
week or Sunday. Then you just do a vlookup as list above

Cheers

A


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=475514



  #6   Report Post  
Old October 13th 05, 03:49 PM
HT
 
Posts: n/a
Default

Theim,

I am not familiar with creating these functions..but I would like to be
...how would I?

Thank you.


"Thiem" wrote in
message ...

12/05/06 =WEEKDAY(A2,1) =VLOOKUP(B2,$A$11:$B$17,2,FALSE)

13/10/05 =WEEKDAY(A4,1) =VLOOKUP(B4,$A$11:$B$17,2,FALSE)

12/05/04 =WEEKDAY(A6,1) =VLOOKUP(B6,$A$11:$B$17,2,FALSE)




2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
1 Sunday



First read the Weekday Fuction to understand, If you start your week on
a Sunday, the ref to enter will be 1, meaning 1 will be first day of the
week or Sunday. Then you just do a vlookup as list above

Cheers

A


--
Thiem
------------------------------------------------------------------------
Thiem's Profile:

http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=475514





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
Converting Date to Work Week... PokerZan Excel Discussion (Misc queries) 4 September 1st 05 09:47 PM
insert the last date when the file was modifie Chetoos Excel Discussion (Misc queries) 1 September 1st 05 03:59 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
Returning the Week Number of a Specific Date on a Month arjcvg Excel Worksheet Functions 1 November 3rd 04 05:35 AM


All times are GMT +1. The time now is 02:24 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017