| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date field from text field
DataText to ColumnsNextNextColumn Data FormatDateYMDFinish.
Gord Dibben MS Excel MVP On Tue, 21 Jul 2009 15:36:10 -0500, Jack Deuce wrote: I have 2 sheets containing two dates that I need to compare. One date is in the serial date format, ie, shows as 07/21/04 (internal 39650). The other date field has been formatted as text with a date containing 20090721. How can I convert this text date to a formatted date field that can be used as the serial date for the date compare? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New date based on one date field minus minutes in another field | Excel Discussion (Misc queries) | |||
| Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
| Converting a date field into a month-year only field | Excel Discussion (Misc queries) | |||
| Changing a text field to a date field | New Users to Excel | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
