I have date in say column b.
I need to have year, month and date from column b to
column c, column d and column e so I can sort data
by month or date.

I know it is simple formulae but have forgotten it.

Appreciate help.

thanks much

vikkam



--
vikkam
------------------------------------------------------------------------
vikkam's Profile: http://www.excelforum.com/member.php...fo&userid=1266
View this thread: http://www.excelforum.com/showthread...hreadid=565419

how is

=MONTH(B1)
=DAY(B1)
=YEAR(B1)

for simple?


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=565419

Hi Vikkam,

Have a look at http://www.cpearson.com/excel/datetime.htm
--
Hope this helps,
MarkN


"vikkam" wrote:


I have date in say column b.
I need to have year, month and date from column b to
column c, column d and column e so I can sort data
by month or date.

I know it is simple formulae but have forgotten it.

Appreciate help.

thanks much

vikkam



--
vikkam
------------------------------------------------------------------------
vikkam's Profile: http://www.excelforum.com/member.php...fo&userid=1266
View this thread: http://www.excelforum.com/showthread...hreadid=565419

Thanks much for your e-mail.

Basically as explained I need 2nd column to oick up only
date portion of the column1. 3rd column to pick up
month portion of column 1. 4th column to pick up year.

For example
columnA columnB columnC columnD
12/01/1952 01 12 1952

With these I can sort the data as per column C and then Column B.
I will get list with month and day in chronological order.

I hope I have been able to explain my self.

I tried formatting columnB as DD (=$A1) and Column C as MM (=$A1)
but while sorting it picks up entire date and sorts by age.

Thanks for your help.

confused vikkam



--
vikkam
------------------------------------------------------------------------
vikkam's Profile: http://www.excelforum.com/member.php...fo&userid=1266
View this thread: http://www.excelforum.com/showthread...hreadid=565419

Excelenator

Sorry did not see yourmail b4 my last reply.
Thanks much. It solved one problem.
However the cell has to be formated as text
to display correct value. I am not sure if it will
sort correctly.
Will try tomorrow morning and see.

Thanks once again cool dude.

vikkam

how is

=MONTH(B1)
=DAY(B1)
=YEAR(B1)

for simple?


--
vikkam
------------------------------------------------------------------------
vikkam's Profile: http://www.excelforum.com/member.php...fo&userid=1266
View this thread: http://www.excelforum.com/showthread...hreadid=565419