I have this weird excel problem where excel won't calculate dates correctly. I had these dates in a column A:
10/12/2012 11/12/2012 12/12/2012 13/12/2012 14/12/2012 and so on.
In column B I wanted excel to calculate the next date. Everything was fine up to 12/12/2012. After that it shows
#VALUE. I thought it was a date format problem and tried every available option, but it simply won't work.