Hi,

I am stuck on a simple (I think) problem.

In my worksheet a column of data contains dates (in dd/mm/yyyy time
format). I have used vlookup to pull this data accross to another
worksheet in the book, however I only want the second sheet to display
the day (ie Wednesday). How do I format the cell to do this...

Any help welcomed


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=510531