Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Location
    Kamloops, Br. Columbia, Canada
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Equivalent of ISNUMBER for a date (XP)

    I am using =LEFT in B1 to isolate the 1st 8 characters of A1. In C1 I want to test whether B1 is a date. If it is a date, I want to include the status in an IF statement. I've tried ISNUMBER but it returns false. I guess there is no equivalent function for a date. Is there a formula that will accomplish this?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Equivalent of ISNUMBER for a date (XP)

    What are you trying to test exactly?

    A date is any number from 0 to 2,958,465 that is formatted as a date. If you to test if it is formatted as a date, it will require a user function. Excel "proper" does not distinguish between the number 38,450 and the date April 8, 2005. The values are equivalent in every way. The only difference is the display.

    Steve

  3. #3
    New Lounger
    Join Date
    Feb 2005
    Location
    Kamloops, Br. Columbia, Canada
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Equivalent of ISNUMBER for a date (XP)

    Steve, Column A contains could contain text such as 03/11/05 to 03/12/05 or a description such as xyz. I want to extract the from and to dates and put them into separate coumns and then format them as dates.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Equivalent of ISNUMBER for a date (XP)

    The following formula will return TRUE if the first 8 characters in A1 form a date, FALSE otherwise:

    =NOT(ISERROR(DATEVALUE(LEFT(A1,8))))

Posting Permissions

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