| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format date time
5/12/2005 1:20:33 PM = text field
10/20/2004 10:02:40 AM = text field I need to extract just the date and ignore the time. Tried =MID(F2,1,9) and it worked for 5/12/2005 1:20:33 PM. Output showed 5/12/2005 Apparently this would not work for 10/20/2004 10:02:40 AM. Output would show 10/20/200. Is there a work-around for this or a different formula that can be used? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
| DOS Data in Excel Format with Date and Military Time in same cell | Excel Worksheet Functions | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
| Subtracting time in date format | Excel Worksheet Functions | |||
Threaded Mode
