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

G

Gautam

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
 
J

JE McGimpsey

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"
 
D

Danny@Kendal

Gautam said:
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.
Click to expand...

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)
 
S

Sloth

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.
 
Top