• Date Format Wrong

    Author
    Topic
    #494642

    I have a simple formula that subtracts one date from another. Although I have formatted the cells to YY-MM-DD unless I enter the date as 2014-05-05 it throws up an error. In the formula bar it changes the date to American format – MM-DD-YYYY.
    Any idea’s what is happening.
    I have uploaded a screenshot so you can see what I mean.

    36951-2014-05-07_15-40-34

    Thanks in advance

    Alan

    Viewing 1 reply thread
    Author
    Replies
    Viewing 1 reply thread
    Reply To: Date Format Wrong

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: