Which date format is good to use in excel?That should support all regional languages and for all system date formats. RRS feed

  • Question

  • Hi,

        I have been worried to fix this problem from past three days,like 

        Range("AX1") = FormatDateTime((Docx.getAttribute("r1ed")))
        Range("AX2") = FormatDateTime((Docx.getAttribute("r2ed")))
        Range("AX3") = FormatDateTime((Docx.getAttribute("r3ed")))
        Range("AX4") = FormatDateTime((Docx.getAttribute("r4ed")))

    above is my vba code,that considers system date format,but if I change my system`s language and date format separated by ".","/","-" Then excel cell shows incorrect date format. Due to this my formulas' throws error since after susbtracting two cells like "AX1 - AX2" it shows "#Value!". 

    Please suggest me a way for this that should for all excel versions,all languages and date separations.

    Thanks in advance.


    • Moved by JesB Tuesday, October 15, 2013 8:28 PM Off-Topic Post
    Saturday, February 23, 2013 12:28 PM


  • Hi,

    This forum is for app developers who are trying to publish apps for Office or SharePoint 2013 and issues surrounding that process. You might want to search for this question or ask in the Answers forum here which may be of better use for your question:


    Best regards,

    Jes Brown

    • Proposed as answer by JesB Saturday, February 23, 2013 8:59 PM
    • Marked as answer by JesB Monday, February 25, 2013 5:46 PM
    Saturday, February 23, 2013 8:59 PM