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.

`B`

? – CharlieRB Apr 16 '13 at 12:01