| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date field from text field
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date field from text field
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? One way: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date field from text field
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? If the cell with 20090721 is cell H1, try the following formula: =DATE(MID(H1,1,4),MID(H1,5,2),MID(H1,7,2)) Hope this helps / Lars-Åke |
|
#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? |
| Reply |
| 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) | |||
Hybrid Mode
