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.
Thanks in advance
Alan