+ Reply to Thread
Results 1 to 2 of 2

Date Format Question- convert into a usable date format.

  1. #1
    Josh O.
    Guest

    Date Format Question- convert into a usable date format.

    I have a date field that I need to convert into a usable date format.
    The current date is input into a field as yyyymmdd. But the number is
    entered as text. Is there a way to format that number or a formula to use to
    make that format usable? What I want to use the date for is to create a
    formula that calculates the days past due. For example, =("invoice
    date"+30)-today( ).
    However the formula won't work with the date in its current format.

  2. #2
    Peo Sjoblom
    Guest

    re: Date Format Question- convert into a usable date format.

    Data>text to columns, click next twice, under column data format select date
    and YMD,
    click finish

    for a formula solution assuming they always have 8 digits

    =DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))


    --

    Regards,

    Peo Sjoblom


    "Josh O." <JoshO@discussions.microsoft.com> wrote in message
    news:CCA2BCE8-F58F-41AB-A4B6-2A3915DA9BEE@microsoft.com...
    > I have a date field that I need to convert into a usable date format.
    > The current date is input into a field as yyyymmdd. But the number is
    > entered as text. Is there a way to format that number or a formula to use

    to
    > make that format usable? What I want to use the date for is to create a
    > formula that calculates the days past due. For example, =("invoice
    > date"+30)-today( ).
    > However the formula won't work with the date in its current format.




+ 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