| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a method to extract the Date from a cell to a new cel
Good point. It's probably more readily understood by most users than my approach.
-- John Green - Excel MVP Sydney Australia "shockley" wrote in message ... This works too: =DATE(YEAR(A1),MONTH(A1),DAY(A1)) =TIME(HOUR(A1),MINUTE(A1),SECOND(A1)) Shockley "Paul" wrote in message ... Need a method to extract the Date from a cell to a new cel. the curent value of two cells a 10/31/2003 3:34:48 PM 8/22/2003 7:29:08 PM While I am at it, how do I extract the time also |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract date from last cell | Excel Discussion (Misc queries) | |||
| extract year from the date in a cell | Excel Worksheet Functions | |||
| extract name when a date in another cell gets near | Excel Worksheet Functions | |||
| extract name when a date in another cell gets near | Excel Discussion (Misc queries) | |||
| Extract date from cell | Excel Worksheet Functions | |||
![John Green[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
