Returning a Day from a numerical date formatt

[CliveH]

Hello

Can someone tell me if there is a formula that can display the actual day from a numerical date:

ie

Cell A1 - 07/06/2013
Cell B1 - Friday

TIA
Clive

[JBeaucaire]

Formula in B1: =A1
Format on cell B1: "DDDD"

Highlight the cell, press CTRL-1, then select Number tab, select CUSTOM and apply the format DDDD.

[akhileshgs]

or may be

=TEXT(A1,"dddd") 

Change ref as per your need

[CliveH]

Thanks guys!!