Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Date formula?

  1. #11
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    However, 2832002 will not work.

    In a nutshell, the day (mmddyyyy) or month (ddmmyyyy) must have 2 digits for these to work.

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-28 13:26, Russell Hauf wrote:
    However, 2832002 will not work.

    In a nutshell, the day (mmddyyyy) or month (ddmmyyyy) must have 2 digits for these to work.
    Russell, it's not unreasonable (in fact it's neccessary) to assume that days will always be entered as DD; otherwise, there would be considerable ambiguity for 1122002. Is this 11/2/2002 or 1/12/2002? Gotta have some ground rules! Right?

    [ This Message was edited by: Mark W. on 2002-03-28 13:42 ]

  3. #13
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Exactly. If they aren't entered like that then the solution is not Excel-oriented. But I've seen some interesting stuff at work that would surprise you.

  4. #14
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-28 13:55, Russell Hauf wrote:
    Exactly. If they aren't entered like that then the solution is not Excel-oriented. But I've seen some interesting stuff at work that would surprise you.
    Surprise me? Not a chance! "Interesting stuff" is quite pervasive. BTW, while sitting in cross-town traffic I realized that my formula...

    =TEXT(REPT(0,8-LEN(A10))&A10,"00-00-0000")+0

    ...can be further simplified to...

    =TEXT(A10,"0-00-0000")+0

    Excel will coerce the text string into the correct date value with or without the leading zero.

  5. #15
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mark:
    That is SUPER! short and sweet ...

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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