date extraction howto?
 

hello,

I want to extract numbers from a date generated by excel
example:
cell a 119 contains as value 10/30/2003
now i want to use a formula that extracts the 10 and place that into
another cell.
Another formula must extract 30 and place this into another cell
and the last formula schould extract the 2003 and place this into
another cell.

so a119 = 10/30/2003
e.g.
a120 = 10
a121 = 30
a122 = 2003

Regards,

Niek



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

date extraction howto?
 

=Month(A119)
=Day(A119)
=Year(A119)

--
Regards,
Tom Ogilvy


"solo_razor" wrote in message
...
hello,

I want to extract numbers from a date generated by excel
example:
cell a 119 contains as value 10/30/2003
now i want to use a formula that extracts the 10 and place that into
another cell.
Another formula must extract 30 and place this into another cell
and the last formula schould extract the 2003 and place this into
another cell.

so a119 = 10/30/2003
e.g.
a120 = 10
a121 = 30
a122 = 2003

Regards,

Niek



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/