| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days and Dates look up
1/2/2008 VC 2.00
5/21/2008 VC 10.00 5/30/2008 VC 10.00 5/31/2008 VC 10.00 6/21/2008 VC 10.00 6/22/2008 VC 10.00 Is it possible to correlate dates with days by looking up a 2008 calendar? What I am trying to do is find day of the week which corresponds with the date (e.g. 01/02/08 - Wednesday). Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Days and Dates look up
What exactly do you want to do with this?
Both 1/2/2008 and 5/21/2008 are Wednesdays. -- Biff Microsoft Excel MVP "da" wrote in message ... 1/2/2008 VC 2.00 5/21/2008 VC 10.00 5/30/2008 VC 10.00 5/31/2008 VC 10.00 6/21/2008 VC 10.00 6/22/2008 VC 10.00 Is it possible to correlate dates with days by looking up a 2008 calendar? What I am trying to do is find day of the week which corresponds with the date (e.g. 01/02/08 - Wednesday). Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Days and Dates look up
There are 2 ways. You can either set the format of the cell where the data
is in, so when the date is entered, you just see the day of the week. Or you can also use a formula in another cell. The formula is: "=text(a1,"dddd") where a1 is pointing to the cell where your date is in. Storm "da" wrote: 1/2/2008 VC 2.00 5/21/2008 VC 10.00 5/30/2008 VC 10.00 5/31/2008 VC 10.00 6/21/2008 VC 10.00 6/22/2008 VC 10.00 Is it possible to correlate dates with days by looking up a 2008 calendar? What I am trying to do is find day of the week which corresponds with the date (e.g. 01/02/08 - Wednesday). Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Days and Dates look up
For each date, I want to list corresponding Day in the next column.
"T. Valko" wrote: What exactly do you want to do with this? Both 1/2/2008 and 5/21/2008 are Wednesdays. -- Biff Microsoft Excel MVP "da" wrote in message ... 1/2/2008 VC 2.00 5/21/2008 VC 10.00 5/30/2008 VC 10.00 5/31/2008 VC 10.00 6/21/2008 VC 10.00 6/22/2008 VC 10.00 Is it possible to correlate dates with days by looking up a 2008 calendar? What I am trying to do is find day of the week which corresponds with the date (e.g. 01/02/08 - Wednesday). Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Days and Dates look up
Thank you so much. It was so easy to copy the formula and find the days which
correspond the dates. It worked. 3/29/2008 Saturday 4/2/2008 Wednesday 4/3/2008 Thursday 4/4/2008 Friday 4/5/2008 Saturday Have a great weekend. "Storm" wrote: There are 2 ways. You can either set the format of the cell where the data is in, so when the date is entered, you just see the day of the week. Or you can also use a formula in another cell. The formula is: "=text(a1,"dddd") where a1 is pointing to the cell where your date is in. Storm "da" wrote: 1/2/2008 VC 2.00 5/21/2008 VC 10.00 5/30/2008 VC 10.00 5/31/2008 VC 10.00 6/21/2008 VC 10.00 6/22/2008 VC 10.00 Is it possible to correlate dates with days by looking up a 2008 calendar? What I am trying to do is find day of the week which corresponds with the date (e.g. 01/02/08 - Wednesday). Thank you |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Days and Dates look up
Ok, I see "Storm" gave you a solution.
-- Biff Microsoft Excel MVP "da" wrote in message ... For each date, I want to list corresponding Day in the next column. "T. Valko" wrote: What exactly do you want to do with this? Both 1/2/2008 and 5/21/2008 are Wednesdays. -- Biff Microsoft Excel MVP "da" wrote in message ... 1/2/2008 VC 2.00 5/21/2008 VC 10.00 5/30/2008 VC 10.00 5/31/2008 VC 10.00 6/21/2008 VC 10.00 6/22/2008 VC 10.00 Is it possible to correlate dates with days by looking up a 2008 calendar? What I am trying to do is find day of the week which corresponds with the date (e.g. 01/02/08 - Wednesday). Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Days between dates | New Users to Excel | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| days and dates | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Linear Mode
