After a date entry is made, only displaying the Day

[Alec H]

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

[daddylonglegs]

use custom format

dddd

[Niek Otten]

Format Custom, "dddd"

--
Kind regards,

Niek Otten

"Alec H" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Alec H]

Thank you for your help