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"

 

[Alec H]

Thank you for your hel