|
|
|
|
#1
02-13-2017, 05:32 PM
|
|||
|
|||
You could use this to extract out the date =TRIM(LEFT(A1,FIND(" ",A1)))+0 
|
|
#2
02-13-2017, 05:42 PM
|
|||
|
|||
|
Sorry, I'm not sure I get it.
Here's what I have: A1 = 2/14/2017 11:14:58 AM A2 = 02/12/2017 12:40 Obs. I have 50 different lines, these are just examples Can you explain to me how to do it?  Tks
|
|
| Tags |
| dates, vba |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula/VBA to identify order of entry dates
|
lesmielles | Excel Programming | 3 | 02-08-2017 06:14 AM |
|
IF formula using dates
|
rindelsk | Excel | 1 | 04-06-2015 01:15 AM |
|
IF Formula to calculate dates
|
Sophie1 | Excel | 2 | 04-23-2014 07:19 AM |
| If formula for subtracting dates | gbaker | Excel | 6 | 10-07-2012 07:06 AM |
| Excel 2007 - formula or macro/vba code required | wrighty50 | Excel Programming | 3 | 05-13-2012 02:24 PM |
Windows Vista 
Office 2007
Hybrid Mode