You have different options depending on what you need.

=TEXT(A1,"dddd")
will return Monday as a text string

=A1
formatted as
dddd
will show as Monday, but the cell value will be equal to the date

=DAY(A1)
will return 12 (the twelth day in the month)

=WEEKDAY(A1)
will return 2 (the second day in a week; Sunday=1)

Hope this helps.

"Gautam" wrote:

Hi,
i want to know if i have a cell with the date format, in which they show the
day, & month, like:
Monday, December 12, 2005
its a formatted cell,
now if i want to pull the day in a diff. cell, what is formula for that
pls. give me some solution for that

Regards
Gautam