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