Date formula? - Page 2
Date formula?
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,605
    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,605
    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 ...

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
  •  

 

 
DMCA.com