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