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.
No comments:
Post a Comment