+ Reply to Thread
Results 1 to 12 of 12

I hate excel so much those days

  1. #1
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    I hate excel so much those days

    I've spent whole week to match two dates within VBA.
    And I'm still not sure I've did it.

    In 25 years there were so many Excel versions - but they are stil unable to do a simple thing: Match two equal dates.

    And since I've read almost whole Internet outhere trying to figure it out: I think I need a detox

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: I hate excel so much those days

    Zbor
    I rarely use VBA but when I have tried to do code with dates different from the US format I've experienced grief too. Just a suggestion, could you not ask Robin? He seems smart.

    DBY

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: I hate excel so much those days

    Hey Zbor,

    There is this help forum on the WWW that you can ask questions about Excel and other people can share your grief or even sometimes help to find an answer. It is hard to answer a question without seeing a sample workbook.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: I hate excel so much those days

    My sample workbook is totaly blank.
    It's a first Circle of Hell

    After that become worse.
    Dates a 9th Circle

  5. #5
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: I hate excel so much those days

    As long as you stick to numbers & ISO standards.

    Please Login or Register  to view this content.



  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: I hate excel so much those days

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    haha sorry, couldnt resist that 1, my friend
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: I hate excel so much those days

    Quote Originally Posted by MarvinP View Post
    ....There is this help forum on the WWW that you can ask questions about Exce.....
    Yeah, I heard that too.......

    Listen, zbor, dates are easy.......but don't use VBA, that'll kill you - formulas rule OK!!!
    Audere est facere

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: I hate excel so much those days

    I used to be good with dates too - then I got married. had to stop the dates after that

  9. #9
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: I hate excel so much those days

    That fits with the "circle of hell" comment made above!

  10. #10
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: I hate excel so much those days

    Quote Originally Posted by zbor View Post
    And since I've read almost whole Internet outhere trying to figure it out: I think I need a detox
    Reading on a screen is difficult. My advice: print the entire Internet first, then read.

  11. #11
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: I hate excel so much those days

    Quote Originally Posted by daddylonglegs
    Listen, zbor, dates are easy.......but don't use VBA, that'll kill you - formulas rule OK!!!
    I think I have proof for Wormholes.

    Quote Originally Posted by FDibbins
    I used to be good with dates too - then I got married. had to stop the dates after that
    Do you know what wife do when want to limit access to the computer for her husband?
    Put a wedding day as a password.

    Quote Originally Posted by Pepe Le Mokko
    Reading on a screen is difficult. My advice: print the entire Internet first, then read.
    Hm.. This will take some time... maybe I'll just leave it till tomorrow.

  12. #12
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: I hate excel so much those days

    What are the Date?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-17-2013, 03:17 PM
  2. Converting from Excel 2003 to 2010 and HATE IT!
    By crspong in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-15-2012, 07:58 PM
  3. Replies: 3
    Last Post: 05-03-2012, 04:59 PM
  4. I HATE excel & dates
    By kestrel in forum Excel General
    Replies: 1
    Last Post: 03-10-2005, 09:45 AM
  5. I'm really starting to HATE excel !!!
    By Future Leader in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-03-2005, 08:50 AM

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