Days and Dates look up

[da]

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

 

[T. Valko]

What exactly do you want to do with this?

Both 1/2/2008 and 5/21/2008 are Wednesdays.

 

[Storm]

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]

For each date, I want to list corresponding Day in the next column.

 

[da]

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.

 

[T. Valko]

Ok, I see "Storm" gave you a solution.