If the cell has the date, just link directly to the cell and format as
"dddd":

A1: Monday, December 12, 2005
B1: =A1

Format B1 with Format/Cells/Number/Custom "dddd"

In article ,
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