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