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?