+ Reply to Thread
Results 1 to 3 of 3

Convert Text Dates, Perform Calculation, Convert back to Text

  1. #1
    Registered User
    Join Date
    03-03-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    53

    Convert Text Dates, Perform Calculation, Convert back to Text

    I have a project where the dates are all in Text format and to add to the problem many of ther dates are pre 1900 which Excel does not like. The other piece of information I have is a period of time which may be recorded as Days, Months or Years but I can work with that OK.

    So I would like to take a text date like 24 September 1872 and for example subtrach 14 days from it to result in 10 September 1872.

    I am thinking I am going to have to convert the text date, do the subtraction and then convert back to text so Excel will be happy with the pre 1900 date format but I have no idea where to begin.

    All help and pointers very welcome.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Convert Text Dates, Perform Calculation, Convert back to Text

    this may help
    http://www.exceluser.com/explore/earlydates.htm
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    03-03-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Convert Text Dates, Perform Calculation, Convert back to Text

    Thanks, been offline for a few days hence the late reply, also think I formed another work around in my head.

    Thx again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1