Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date extraction | Excel Worksheet Functions | |||
Date extraction from data pull | Excel Discussion (Misc queries) | |||
howto: concat (x1:x3) | New Users to Excel | |||
HOWTO Replace from Row | Excel Programming | |||
HOWTO Replace from Row | Excel Programming |