how to split the cell which has the date formula (with day)
 

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

how to split the cell which has the date formula (with day)
 

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

how to split the cell which has the date formula (with day)
 

"Gautam" wrote in message
...
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.

Something like this any good?

A1 =NOW()

B1 =YEAR(A1)
C1 =MONTH(A1)
D1 =DAY(A1)
E1 =HOUR(A1)
F1 =MINUTE(A1)
G1 =SECOND(A1)

how to split the cell which has the date formula (with day)
 

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